Sub Totals

[Anonymous]

Hi guys,

Is there possible to show sub total for whole set?

For example:

Store Country   Zone District  Count

1        Canada   2         25         5

2        Canada   2         25         3

3        Canada   2         25         1

4        Canada   2         25         10

TOTAL                                     19

8         Canada   2         26         15

10        Canada   2         26         13

13        Canada   2         26         11

14        Canada   2         26         20

TOTAL                                      59

???

I used show partial sums, it works only when I select my District

[#2]

Attached. You have to use 'Show partial sums' for Store and have Store as the last Dimension. The hierarchy should be intact. Highest level dimension first then the next and so on.

Thanks

[Anonymous]

Yes, it works, but in my case store is on first place.

[reshmakala]

Why dont you demote the position of the dimension?

[Anonymous]

The client sent an example with store level in begging.

[stevedark]

Your best bet is to explain to them how Pivot tables function in QlikView, and why the group you are totalling must be to the left hand side.

However.  If that is not going to work you may be able to do something by putting in a dummy dimension.  If you create a calculated dimension to go first, with a value of:

=Dual('', District)

And a label of:

=' '

Can you then total on that dimension?

The dual function will maintain the numeric value of the district, but will display the empty string as the text, so you will get a blank column on which you can do the total.  You will probably want to set the Total label to =' ' as well, so you can make the dummy column as small as possible.

Just a thought.

Steve