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
Quote from: chinnu on 01 Jun 2021 08:58:29 AM
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.