Customized Crosstab summarized values

[chinnu]

Hello Gurus,

I have a requiremenet where crosstab summarized values needs to be customized.
This is how the requirement is

Items   Jan   Feb    Mar    Apr   [2020 Avg]   MoY% ( (current month- 2020 avg)/ 2020 avg) in % format
A1           20   40   40   60   55                    9%
A2           40   60   15   80   35                    128%
A3           30   50   80   25   40                    -37.5
Totals   90   150   135   165   130             (Here I need (total(Apr)-total(2020 Avg)/total(2020 Avg) instead of total of MoY%)

I tried to DEFINE CONTENTS to YES for MoY% summary crosstab intersection and manualy created data item in query and placed using query calculation. But the blank value is displaying

Am I missing  anything here? Please guide me

[MFGF]

Hello Gurus,

I have a requiremenet where crosstab summarized values needs to be customized.
This is how the requirement is

Items   Jan   Feb    Mar    Apr   [2020 Avg]   MoY% ( (current month- 2020 avg)/ 2020 avg) in % format
A1           20   40   40   60   55                    9%
A2           40   60   15   80   35                    128%
A3           30   50   80   25   40                    -37.5
Totals   90   150   135   165   130             (Here I need (total(Apr)-total(2020 Avg)/total(2020 Avg) instead of total of MoY%)

I tried to DEFINE CONTENTS to YES for MoY% summary crosstab intersection and manualy created data item in query and placed using query calculation. But the blank value is displaying

Am I missing  anything here? Please guide me

Have you tried unlocking the structure and dragging your item or expression into the summary footing for M0Y%? This usually works.

Cheers!

MF.