Saturday, March 02, 2013 11:06 AM
I want to determine the Top 5 clients by sessions conducted from inception till date. So i dragged clients to the row labels, year to the column labels and Sessions conducted to the Value area.
Sessions conducted is a calculated field formula computed as
=CALCULATE([Distinct sessions] ,DATESBETWEEN(Calendar1[DateKey] ,STARTOFYEAR(LASTDATE(Calendar1[DateKey]),"3-31") ,endOFYEAR(LASTDATE(Calendar1[DateKey]),"3-31") ) )
Distinct sessions is a calculated field formula computed as
The sessions conducted calculated field formula shows me the correct result so no problem so far. However, I do not see the row wise grand total i.e. client wise session totals. The column wise grand totals appear just fine. Since the row wise grand totals are missing, I cannot sort for Top5 clients in the Pivot Table.
Why are the row totals missing?
Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com