Totals within Pivot Table

[sunny_talwar]

** Update: Attached the sample QlikView file **

Hey Guys,

I have three Dimensions (Category, Item and Supplier). Each category can have multiple items in it. and I am trying to get here

Item	Sup1	Sup2	Sup3	Sup4	Total
Item1	1	1	1	1	4
Item2	1	1	1	1	4
Item3	1	1	1	1	4
Item4	1	1	1	1	4
Item5	1	1	1	1	4
Total	5	5	5	5	20

But Right now I am getting this using the following expression: =Count(DISTINCT TOTAL <Item, Category> Item)

Item	Sup1	Sup2	Sup3	Sup4	Total
Item1	1	1	1	1	1
Item2	1	1	1	1	1
Item3	1	1	1	1	1
Item4	1	1	1	1	1
Item5	1	1	1	1	1
Total	5	5	5	5	5

How do I make it so that it shows the total at both the ends?

Any help would be greatly appreciated.

Best,

S

[Colin-Albert]

On the Chart Properties Presentation Tab, click on "Partial Sums" for the field at the level beneath the one you want the total to show against.

[sunny_talwar]

Hi Colin,

Thanks for your response. I see the totals (already have the selected). The problem is that One of the totals is not what I want it to be (Last Column on the above attached table).

Best,

S

[Colin-Albert]

The last column I can see is Sup4, both screenshots are the same in your post.

[sunny_talwar]

There is scroll bar at the bottom of my initial post, if you scroll to the right, you will see Total there.

Best,

S

[Anonymous]

can you please post the sample qvw file with explanation. i dont see category dimension and what you are trying to acheive. Please explain clearly.

[sunny_talwar]

I don't have a sample qvw right now, but I can work on preparing one. Once I have that I will post it here.

Thanks for you help Vinay,

Best,

S

[sunny_talwar]

Attaching a sample QlikView file. Let me know if still anything is unclear.

Best,

S

[Anonymous]

is that you are expecting

[Anonymous]

is this you are expecting