Discussion (3)1
Log in or sign up to continue

Hi, Alessandro! Thanks! 

Yes, I was asking about how to show the number of rows.

I managed one approach with Expression on the Column and introducing Total like this:

 

With the MDX Expression:

SELECT NON EMPTY {[Measures].[Amount Sold],%LABEL(1,"To calculate the rows","")} ON 0,NON EMPTY [Outlet].[H1].[Region].Members ON 1 FROM [HOLEFOODS]

Along with the setting for the Pivot in Analyser to show the Grand Total.

So, do you have the way to make it via MDX only?

In the options for pivot table you can use Count instead of Grand Total as Summary. However, you will have to choose between the Grand Total and Count. If you calculate the grand total in some other way (for example by placing another [Outlet].[H1].[Region].Members and then Gear icon > Compute Aggregate > SUM), that COUNT will also count the cell with the Grand Total. 

Otherwise you can create a "Row Number" calculated measure with the expression below and place it on measures next to Revenue

COUNT(%CELL(-1,0))-1+%CELL(0,-1)