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.