Sub total issue in Pivot table

[kkkumar82]

Hi all,

I have a pivot table with two dimensions and one measure. Which looks like this.

Is there a way that I can add up the first two dimension values totals and display as below.

I am attaching a qvw file with sample data which may be useful. Also giving a table box which contains sample data.

Thanks

Kiran Kumar

[kkkumar82]

Any work around from edit script??

Thanks

Kiran Kumar

[lironbaram]

you'll need to create

another dimension that group the two levels

have a look at the attach example

[#4]

I've noticed you are grouping already by ProductRecordKey,

Why don't you create combined cost type in the script?

[#5]

As Liron said, you will need to crate another dimension.  I would suggest a method that is dynamic as possible.  You may want to expand his solution to use nested 'If' in case you have more than the 2 types shown

[kkkumar82]

Actually that key is a link to my fact table.

Thanks

Kiran Kumar

[kkkumar82]

Hi Liron,

Thanks for your solution, the only problem I have in this solution is my customers are going to download the file where they will see an extra column( the first one ) for the whole data. In original the table is very huge.

Thanks

Kiran Kumar

[kkkumar82]

Hi all ,

Finally I was able to crack this with the help of the following link,

Qlikview Subtotaling Customization: Part 2 |

the solution is almost same as of Liron but a data modeling change is additional.

Thanks all.

Kiran Kumar

[kkkumar82 · Accepted solution]

I have also attached the final qvw with desired output.

Thanks

Kiran Kumar

[Kushal_Chawda]

Using some script & Front end you can do this like in attached