Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can Measure Result be used for Creating a Chart?

Hi,   I have a data table as below. I used measure to calculate the Last Year Sales numbers and categorized the Sales Trend. For the Sales Trend, if this year sales is bigger than last year sales, ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Rico,

 

Thanks for the insights.

When I take out the country column from the table you created, the SKU list and sales numbers do not summ up. How to make it summ up, including the Sales Trend?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

    • tex628's avatar
      tex628
      Icon for Community Champion rankCommunity Champion
      6 years ago

      There 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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