Forum Discussion
Can Measure Result be used for Creating a Chart?
tex628 Thanks for your feedback.
But, you should not delete the rows. In my real data, I have multiple SKUs by Countries, by Business, stc.
I forgot to say something. If you add the total in the table, the numbers are also not correct.
Community ChampionThere might be some slight missunderstanding here.
In your original excel chart, can you explain what exactly is being summed in the green and red parts of the chart?
Br,
J
tex628 the chart is only a visual example, not based on the data I provided.
The color represent the total Summ of Sales Gap, it is green if the sum is positive and red if negative. The X axis must be able to changet to Country or SKU.
Can you please work with my sample data here: https://1drv.ms/x/s!Ald6vpsRS30Qg7EMQCC_QnWxy8UyyQ?e=svz1w6
My objectives are to create the table as you can see in 2020 Mix tab and the Chart in the Chart Tab. The X axis of the card must be able to changed to country, group, division, etc to repsesent the summ of Group Mix Amt.
Thanks,
Rizal
- tex628
Alright,
When we are comparing the sales of a 2020 row, which criteria from the 2019 row needs to match?
- Exact date?
- Country?
- Group?
- Division?
- SKU?
/ J- Exact date? Not necessary by date, but by month would be good enough
- Country? Yes
- Group? Yes
- Division? Yes
- SKU? Yes