4 Replies Latest reply: Jun 24, 2014 6:32 AM by Bruno Souza

# 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!

• ###### Re: New subtotal

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

• ###### Re: New subtotal

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.

• ###### Re: New subtotal

Thank you! It works!

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

Example:

100 -> First

200 -> Second

300 -> Third

...

Thanks!

...

• ###### Re: New subtotal

Hi.

Try this one:

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