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
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous added a few more rows to the model for the example. His solutions should still be correct, I removed the rows for you in the file attached below. 

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.