Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me in understanding below code line by line and also logic of putting Total<>,Total<
Pick(Dimensionality()+1,
1,
Sum(TOTAL <>
{<PeriodType={'$(Period)'},=,
/
Sum(TOTAL {<PeriodType={'$(Period)'},=,=,
Sum(TOTAL <
{<PeriodType={'$(Period)'},=,
/
Sum(TOTAL <>
{<PeriodType={'$(Period)'},=,=,
Sum(TOTAL <
{<PeriodType={'$(Period)'},=,
/
Sum(TOTAL <
{<PeriodType={'$(Period)'},=,=,
Sum(TOTAL <
{<PeriodType={'$(Period)'},=,
/
Sum(TOTAL <
{<PeriodType={'$(Period)'},=,=,
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:
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:
Thanks, got it!