Forum Discussion
Can Measure Result be used for Creating a Chart?
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- tex628
With all 5 dimensions as a criteria there is only 70 rows from the 2020 records that have a corresponding 2019 record. I've attched the files below.
/ J