Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Pivot Table

Hi Friends

I have created the following Pivot table

DeptProductJanFebMarTotal
Dept 1A1000200010004000
B3000400020009000
Total40006000300013000
Dept 2A2500200010005500
B30006000200011000
Toal55008000200016500
Dept 2A2500200031007600
B24006000200010400
Total49008000200018000
Total1440022000700047500

In the Grant total row I want to obtain grand total for each product  A and  B

How can I do it pls help

8 Replies
Anonymous
Not applicable

It may be possible...  Can you upload a small sample of your file?

sunny_talwar

Is this what you want???

Capture.PNG

If yes, then look at the attached qvw.

Best,

Sunny

sunny_talwar

It seems I have misunderstood the problem. I am still trying to comprehend the problem.

Anonymous
Not applicable

See attached

(Sorry sunindia‌ for using your file )

sunny_talwar

Or may be this also

Capture.PNG

upaliwije
Creator II
Creator II
Author

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

sunny_talwar

‌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.

jagan
Luminary Alumni
Luminary Alumni

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.