Pivot Table

[upaliwije]

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

[Anonymous]

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

[sunny_talwar]

Is this what you want???

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]

See attached

(Sorry sunindia‌ for using your file )

[sunny_talwar]

Or may be this also

[upaliwije]

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]

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.