Row total not appearing in Pivot Table

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

Answer 1

Hi,

Problem resolved.  Please ignore.

---

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