Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Icon for Helper II rankHelper II
5 years ago

help in calculation

Hi All,   I need you help/suggestion in acheiving the below result. my data has multiple rows for a product with same amount repeating. How would i show the category wise sum of amount but each pro...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

To your matrix visual, drag Category to the row labels.  Write these measures

Measure1 = min(data[Amount])

Measure2 = sumx(summarize(data,data[category],data[product],"ABCD",[measure1]),[abcd])

Drag Measure2 to your visual.

Hope this helps.