locked
Row total not appearing in Pivot Table RRS feed

  • Question

  • Hi,

    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

    =DISTINCTCOUNT(Feedback[Date])

    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

    Saturday, March 2, 2013 11:06 AM

Answers

  • Hi,

    Problem resolved.  Please ignore.


    Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

    • Marked as answer by Ashish Mathur Sunday, March 3, 2013 3:30 AM
    Sunday, March 3, 2013 3:30 AM