Dimensionality Code

[shiveshsingh]

Please help me in understanding below code line by line and also logic of putting Total<>,Total<>,Total<>,Total<> in numr and denominator

Pick(Dimensionality()+1,

1,

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=, ,,,=p()>}$(Value))

/

Sum(TOTAL {<PeriodType={'$(Period)'},=,=,,,,  =p()>}$(Value)),

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,,,=p()>}$(Value))

/

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=,,,,  =p()>}$(Value)),

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,,=p()>}$(Value))

/

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=,,,,=p()>}$(Value)),

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=p()>}$(Value))

/

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=,,,,=p()>}$(Value)))

[kristof_j · Accepted solution]

Maybe this will help

What does the TOTAL qualifier do?

If you add a dimension to your total then you calculate the total on each value of that dimension.

In the article above if you write 'total <City>' then you'll get for:

• Berlin always 5 (the total)
• London always 6
• Paris always 7

[shiveshsingh]

Thanks, got it!