Count distinct rows related to one specific field

[Pierrecl3]

Hello everyone,

My question could seem stupid but I have not found any satisfying answer yet.

I have a PivotTable with 'VideoName' and 'Values' (5 values exactly) in the Rows field.
My problem is to extract/compute/print the number of videos in a specific cell of the spreadsheet. The cell should neither be included into the table nor refer to any row of the table.

Do you have some ideas to do it in an elegant way without too many computations?

Thanks in advance,
Pierre

 

[tallan]

If you click in a measure cell you will drill down into supporting data on a new worksheet. Is this what you were thinking of or did you have something else in mind?

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI

 

[Pierrecl3]

If you click in a measure cell you will drill down into supporting data on a new worksheet. Is this what you were thinking of or did you have something else in mind?

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI

Thanks for your reply Tom.

Unfortunately not