Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New subtotal

Hi,

I need to create two new rows "total" in the positions that I have indicated in the figure. The table is a table pivots.

The totals must be calculated in the following way:

Total (101,102): 1500+2590 = 4090

Total (201,202,203): 850+450+800 = 2100

How can I do?

Thanks!

Immagine.png

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello, Marco

You can use a calculated dimension with a expression like

=Floor(cdc, 100)

or

=Left(cdc, 1)

Put one of those expressions as your first dimension and turn on subtotals for it.

Hope it helps.

View solution in original post

4 Replies
sundarakumar
Specialist II
Specialist II

U can do it if 101 and 102 belong to another hierarchy like 100 and 201,202,203 belongs to the 200 in the same level. I mean if u have data as below.

100     101

            102

200     201

            202

             203

If u don't have hierarchy as shown try to create one with some business logics, since u look interested in summing 101,102 and 201,202,203. If u don't have such level then I thinks its hard.

Once u have that level created u have the option in presentation tab. otherwise I guess it is not possible in Pivot table.

Regards,

Sundar


Anonymous
Not applicable
Author

Hello, Marco

You can use a calculated dimension with a expression like

=Floor(cdc, 100)

or

=Left(cdc, 1)

Put one of those expressions as your first dimension and turn on subtotals for it.

Hope it helps.

Not applicable
Author

Thank you! It works!

Is possibile to change value in red circles in other value?

Example:

100 -> First

200 -> Second

300 -> Third

...

Thanks!

...Immagine2.png

Anonymous
Not applicable
Author

Hi.

Try this one:

=Pick(Left(cdc, 1), 'First', 'Second', 'Third', 'Fourth', 'Fifth', 'Sixth', 'Seventh', 'Eighth', 'Ninth')