Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have created the following Pivot table
Dept | Product | Jan | Feb | Mar | Total |
Dept 1 | A | 1000 | 2000 | 1000 | 4000 |
B | 3000 | 4000 | 2000 | 9000 | |
Total | 4000 | 6000 | 3000 | 13000 | |
Dept 2 | A | 2500 | 2000 | 1000 | 5500 |
B | 3000 | 6000 | 2000 | 11000 | |
Toal | 5500 | 8000 | 2000 | 16500 | |
Dept 2 | A | 2500 | 2000 | 3100 | 7600 |
B | 2400 | 6000 | 2000 | 10400 | |
Total | 4900 | 8000 | 2000 | 18000 | |
Total | 14400 | 22000 | 7000 | 47500 |
In the Grant total row I want to obtain grand total for each product A and B
How can I do it pls help
It may be possible... Can you upload a small sample of your file?
Is this what you want???
If yes, then look at the attached qvw.
Best,
Sunny
It seems I have misunderstood the problem. I am still trying to comprehend the problem.
See attached
(Sorry sunindia for using your file )
Or may be this also
Thanks
This is what I want but in your sample document total of both products appear in one row. Pls modify the same to apper in two rows
Unfortunately there is no way to have two rows for total and that is why we used the concept of Dimensionality to get you the result you were looking for.
Hi,
If you have two products and always displays two products then sunindia solution works fine, what if you have 100 Products? It is not feasible to write this 100 times, instead create a new chart with Product as dimension and use the expression you used in the chart. This is the best solution.
Or you can try Adhoc reporting Adhoc reporting in Qlikview
Regards,
Jagan.