I have a table that has Order Header and Line detail
I have Order #, Customer #, Line #, Price, Qty, and Item Discount, Item Class, Region
I want to show a graph listing a specific class for All Customers for the year, Specific Region for a year, specific customer for a year.
If I do this:
Create Calculation Revenue [Qty] * ([Price] - [Item Discount]) I get revenue
Create Calculation Candy Revenue SUM(IIF([Item Class]="Candy",[Revenue],0,0)) I get candy revenue
Now, I am struggling to Show this candy revenue for All Stores (Regardless of Region), Region 1 and Customer A
I have been unable to find any samples. Any suggestions would be appreciated.
Any sample workbook you can share so it will be easier to look into it?