1 Reply Latest reply on Apr 18, 2018 7:23 AM by Zhouyi Zhang

    Multiple Revenue Views

    Greg Mundt

      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.