Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table (see in the picture), I have two problems:
1) I don't see the grand total at the bottom of the table, but only on the right divided by each year, and I don't even see the grand total on the right
2) I would need to do a set analysis for current month - 12 (month is the one marked in red) and not all months for selected years, but only for current year, current month - 12, my current expression is Sum(CONSUMI_SMC)
Sorry but not solution for that in QlikView??
I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.
This is not the solution to my question.... but where i can see your webinar?
My questions are:
2) I would need to do a set analysis for current month - 12 (month is the one marked in red) and not all months for selected years, but only for current year, current month - 12, my current expression is Sum(CONSUMI_SMC)
and
1) I don't see the grand total at the bottom of the table, but only on the right divided by each year, and I don't even see the grand total on the right