Totals on Horizontal Axis - Pivot Table

[helen_pip]

Hello

I have a pivot table which has 4 dimensions and 1 expression

I have used partial sums to get a total along the vertical side of my table, however I want to show a total on the horizontal of my table

Can anyone help me to achieve this?

Many Thanks

Helen

[kaushiknsolanki]

Hi,

     Hele,

          Check the partial sum option for all dimensions. or the dimension which you have crossed tabbed (Kept above expression)

Regards,

Kaushik Solanki

[#3]

In presentation tab

select field

Check on show partial sum

[helen_pip]

Hello There

Thank you for your response.  I have done this and still only get a total along the left hand side

Dimension 1	Dimension 2	Dimension 3		A	B	C	D	Total
								1
								16
								7
								3
								3
								111
								21
								62
								56
								2
								51
								31
								20
								1
								69
								1
								9
								1
								1

Can you help?

[#5]

Hi ,

I have a similar scenario with Helen, see the excel pivot below

I just need check on the partial sum to get sum of the category but I need the cumulative sum of day

for example :

Mon= 2

Tues=2+3

Wed=2+3+0

Thu=2+3+0+1 and so on.

Please help.

Thanks,

[kaushiknsolanki]

Hi,

     Go to properties ->Presentation Tab ->Here you have a option Subtotals on Top.

     Click on that.

Regards,

Kaushik Solanki

[helen_pip]

Hello

Thank you for your advice, but this just moved my total from the back to the front.  I ahve tried moving to be horizontal, but can get this to move

Any other ideas?

Thanks

Helen

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the application.

Regards,

Kaushik Solanki

[#9]

Hi Helen,

is it posible to send the Qlikview file?

[helen_pip]

Hello

Thanks for this....This works for me