Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a simple database like the following:
Detail | Day1 | Day2 | Day3 | Day4 | Day5 | Day6 | Day7 |
TOTAL | 79 | 690 | 1.294 | 919 | 1.298 | 1.521 | 1.697 |
of which A | 38 | 487 | 868 | 556 | 826 | 1009 | 1133 |
of which B | 41 | 203 | 426 | 363 | 472 | 512 | 564 |
and I used a crosstable to define week distribution:
crosstable (Week_Dett, Distribution_Dett,1)
LOAD *
FROM #TABLE#;
I would like to get a combined chart like the following:
I tried to insert Week_dett like dimension, I added Detail as alternative dimensions and Distribution_Dett as measure, but my result is terrible:
Can you help me, please?
Thank you! 🙂