How to show the name of the dimension in subtotal field?

[bumin]

Hi,

I want to show the name of the dimension in the subtotal line

Group	colour	Sum (value)
a	blue	200
	red	100
	Subtotal  a	300
b	yellow	500
	Subtotal b	500
c	black	300
	magenta	240
	Subtotal c	540
Total		1340

is there any way to do it?

thanks

bumin

[hallquist_nate]

I have been working on this for you, and have not come up with an answer.  However, I did find this previous post:  http://community.qlik.com/ideas/2386

Also, if you have a selection, =GetFieldSelections(FieldName) will produce the desired effect, but you have to have a selection made.  You put this formula in the Presentation tab of the Chart properties, in the Labels for Totals formula box.  You use the field name that is one level above the desired totals column.  So, if you have Regions, then state in a pivot table, you put this formula in the State dimension, and it will populate the Region, when a region is selected.

It isn't a real great solution, but maybe this will inspire someone else to post a better, or correct solution, maybe something with Set Analysis?

[mountaindude]

I am too looking for a way to do this, did you ever find a solution?

thanks,

Göran

[jonathandienst]

Hi

Have you tried playing around with Indent mode (on the Style tab)? It will do most of what you need if you set up the dimensions vertical and horizontal alignment correctly.

One caution - if you need to change the partial totals, you will need to turn off indent mode, change the partial totals and re-enable partial totals, because for some strange reason, the partial totals options are grayed out when indent mode is on.

HTH
Jonathan