7 Replies Latest reply on Mar 20, 2018 7:38 PM by Zhouyi Zhang

    Dimension and Measure in Calculation


      I have 1 measure - Price

      I have 1 dimensions - Doc type


      doc type has values a , b , c , d  , e


      I want to calculate sum of price of doc type  ( a , b , c ) in one calculation and sum of price of doc type ( d , e ) in another calculation.


      anyone can help with calculation??


      attached workbook.

      I need to create a scatter plot between price and doc type. so need 2 calculations