Expand only current month in pivot - Qlik Community

Report Inappropriate Content · ‎2017-01-02

Hi all,

I would like to only have the current month of the pivot expanded by default, and all other months collapsed. This is basically what I'm looking for...I do need the subtotal for the expanded month.

Thanks!

Anil_Babu_Samineni · ‎2017-01-03

Do you mean this Default

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2017-01-05

Sure, however more like the example I provided (month, date, metric)...so if the current month was December it would be at the bottom. And I still need overall total for all rows.