10 Replies Latest reply: Nov 10, 2009 9:14 AM by Ashok Kumar Jayabal

# It is possible to put a subtotal inside a dimension?

Dear all,

I haven't posted anything in a while, now I'm seeing this new forum design... is great!!!

Now, to what matters:

In the attached file, you can see that I have already designed a Pivot Table with results of certain indicators in several categories. But as a requirement from my employeers, I need to put a subtotal row only for certain categories that should not affect the total result. Is there any way to accomplish this?

I guess my question should be better understood seing the attached file.

As usual, thanks for any comments.

• ###### It is possible to put a subtotal inside a dimension?

Hi,

You can have a Calculated Dimension where you can use Aggr() function with your constraints.

Regards,

Amit

• ###### It is possible to put a subtotal inside a dimension?

Hi Amit,

Thanks for your answer, but I'm not certain on how can I use a Calculated Dimension to perform this, could you please explain this further?

Regards,

Andrés Jején

• ###### It is possible to put a subtotal inside a dimension?

Dear All,

I've been following this for a while, but no replies whatsoever... Pls anyone can help me? I'm a bit desperated with this...

Regards

• ###### It is possible to put a subtotal inside a dimension?

Could you try this?

if Your category is 'A' or 'B', you put one value.

If it is rest, you put another?

in your pivot, you use the 'Sub Category' as one more dimension.

• ###### AW:It is possible to put a subtotal inside a dimension?

Hi,

for all I know, the only solution is to use a paramount dimension as it´s descriped by mingming before.

I´ve had already a lot of requirements like this, but i never found a satisfying solution. Also the qlikview-support propose to use a paramount dimension.

Greets

• ###### AW:It is possible to put a subtotal inside a dimension?

Thanks to everyone for your answers... indeed, I had to use the paramount dimension, here's the result:

Regards!

• ###### AW:It is possible to put a subtotal inside a dimension?

Andres, try to explain, because I do not speak English. could put a sample script used

thanks

• ###### AW:It is possible to put a subtotal inside a dimension?

Why can't you just use the Partial Sums option in the pivot's properties?

• ###### AW:It is possible to put a subtotal inside a dimension?

What I need to do is the following: The total "D" is not the sum of all rows but corresponds to SUMPRODUCT (C2: C9, D2: D9) / SUM (D2: D9), and the totals for "A", "B" and "C" correspond to the sum of their ranks.

 Dia A B C D 01-nov 3.711 3.312 2.260 312 02-nov 9.413 8.966 5.672 320 03-nov 9.399 8.385 4.353 342 04-nov 8.718 8.420 6.827 330 05-nov 8.572 7.775 5.737 324 06-nov 7.309 7.069 5.575 327 07-nov 4.709 4.366 3.531 310 08-nov 3.141 3.103 2.882 307 Total 54.972 51.396 36.837 325

• ###### AW:It is possible to put a subtotal inside a dimension?

hi Andres,

Can u attach a sample script used for the above solution.. We are also having the same scenario here...