Using dimensionality with dimension results to change expression

Fri, 16 Sep 2011 17:25:09 GMT

My Situation:

I have 1 dimension that returns 4 results.

Second dimension I set to show partial sums.

So now I have the results of:

Total

I need to be able to create different formulas for the different dimension totals.

Example:

No A total needed.

B Total needs to be the total of A and B

C Total needs to be the totals of A, B and C, but NOT A1

D Total needs to be the totals of A,B,C, and D, but NOT A1

I then need to have the total of total fields which I could have set to dimensionality()=0

Example:

Total of A,B,C,D

Any one have any ideas?

topic Using dimensionality with dimension results to change expression in QlikView