Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am getting the rollup sum value for every month .In a pivot table i need to show the latest month only by quarter wise .
Quarter,Month,Value
Q1,Nov,17000
Q1,Dec,18000
Q1,Jan,18500
Q2,feb,19000
Q2,Mar,19000
Now i want to display in this way using Pivot Table show only the latest month in Total
Q1,Nov,17000
Q1,Dec,18000
Q1,Jan,18500
Total 18500
Q2,feb,19000
Q2,Mar,19000
Total 19000
PFA of Solution.
can you please make it crear what you want exactly?
Sunil
Hi Sunil
I have attached Qvw file in that file a pivot table is created . In pivot table the SUb total for monthName should be shown for latest month.
In my calendar November is the starting Month.
For Q1 the subtotal should be Jan Value
Q2 Apr Value
Q3 Jul Value
Q4 Oct Value
Hi Sunil
Did you understand my requirement?
HAI SRENNI
U HAD THAT QUARTER KA ANSWER
PFA of Solution.