It is possible to put a subtotal inside a dimension?

[#1]

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.

[#2]

Hi,

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

Regards,

Amit

[#3]

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

[#4]

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

[#5 · Accepted solution]

Could you try this?

In Qlikview Load script, add in one more column 'Sub Category',

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.

[#6]

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

[#7]

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

Regards!

[#8]

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

thanks

[Anonymous]

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

[#10]

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