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

    Dimension and Measure in Calculation

    karishma.velisetty.1

      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