topic Re: How to customizing subtotals label on pivot table in QlikView

How to customizing subtotals label on pivot table

wossenhh — Fri, 09 Oct 2015 14:16:36 GMT

Hi ,

I was creating a pivot table for the following sample

Department	Title	Name	Value1	Value2
A	Sales Rep	Mary	100	250
A	Accountant	Jim	151	145
A	Accountant	Joe	200	150
A	Photographer	John	212	854
B	Photographer	Bill	111	714
B	Photographer	Terry	231	540

By using pivot table I want to show the attached excel that shows the subtotal by the titles as "Title + Total" as a label for the group of department. I was using the calculated dimension as '=Title & ' Total', but this shows a total and title for each lines. What I want is to aggregate the title field with the Total label as it is shown on the excel.

Thanks,

Wossen

Re: How to customizing subtotals label on pivot table

Gysbert_Wassenaar — Fri, 09 Oct 2015 14:18:35 GMT

See this discussion: Custom Labels in Pivot Table

Re: How to customizing subtotals label on pivot table

miguelbraga — Fri, 09 Oct 2015 15:29:26 GMT

Hi Wossen,

Refer to the attached files

Please tell me if that's what you're looking for

Have a good Weekend

Re: How to customizing subtotals label on pivot table

wossenhh — Fri, 09 Oct 2015 15:36:53 GMT

Hi Braga,

Thanks for your help. But what I am looking for is to show the label as 'Account Total' instead of just 'Total' for each titles.

Thanks,

Wossen

Re: How to customizing subtotals label on pivot table

jsakalis — Fri, 09 Oct 2015 16:00:22 GMT

I slightly modified Braga's QVW - would this work for you?

I used indent mode on properties style tab.

Re: How to customizing subtotals label on pivot table

wossenhh — Fri, 09 Oct 2015 17:06:53 GMT

Hi John,

That is somewhat close to what I want! Thanks so much!

Wossen

Re: How to customizing subtotals label on pivot table

jsakalis — Fri, 09 Oct 2015 17:08:48 GMT

Glad it works for you!