total issue in pivot !!!

[qliklearnervir]

Hi,

I am working on one expression where i am not able to find out right solution.

i wan to show the table with :

Segment	Mix	Mix %
A	10	0.333333
B	10	0.333333
C	10	0.333333
Total	30

this is easily achievable by  Mix% = SUM(TOTAL  {<Segment>} Mix).

But the problem here is if we need to change the dimension from segment to Market or so on as per conditional dimension selection . this static formula will not work.

i want the dynamic formula where if i change the dimension tan total should change as per dimension subtotal.

Like  Mix%=SUM(TOTAL {<Dynamic Dimension>} Mix )...

Please suggest.

Thanks.

Virendra

[PrashantSangle]

create variable to store your dynamic dimension

and use that variable in your

Mix%=SUM(TOTAL {<$(variableName)>} Mix )

Regards,

[qliklearnervir]

It is not working ...

still showing total values for entire year

[sasiparupudi1]

Aggr(sum(TOTAL<$(=vDynamicDims)> Mix),Dim1)

[qliklearnervir]

I have to add the current year and previous year selection also.

for 2 columns ..

for current year its working file   Sum ( Actual) / Sum (Total < $(Dim1)> Actual) ....

but for previous year ...its not working....