Want to create a Measure, Value want to insert in Rows under category
Hi Everyone, I have data in sales table, which look like, Region REV_REDUCTION_TYPE Gross Amount Net Amount Africa $17730094.9 $15050089.1 Africa Gift Card $0.0 ($7375.0) Africa Samples $0.0 $2436.3 Africa Thorne Advisor $0.0 ($2280.0) Africa UNKNOWN $0.0 ($145585.7) and if you notice their is a difference between Gross amount & Net Amount for blank Rev_Reduction_Type that is off_Invoice. so Off_Invoice = Gross - Net where Rev_reduction_type is blank, but I want show result table like this and I want do only using measures. Region REV_REDUCTION_TYPE Gross Amount Net Amount Africa $17730094.9 $15050089.1 Africa Gift Card $0.0 ($7375.0) Africa Samples $0.0 $2436.3 Africa Thorne Advisor $0.0 ($2280.0) Africa UNKNOWN $0.0 ($145585.7) Africa Off_invoice $0.0 $2680005.8 Thank You Everyone.