Sum and Sumproduct formulas in one Matrix

[ashrat001]

Hi Experts,

Hope you are well. I have a requirment in which I have a few KPIs/measures in a Matrix. I want to apply a custom total in the end of my Matrix but this custom total should apply Sum function for a few KPIs/measures and Sumproduct on other KPIs/measure. Below is the sample:

	Product 1	Product 2	Product 3	Custom Total
Sale	10	15	30	Sum
Production	20	22	40	Sum
Discount	2	4	3	Sumproduct
Cost	500	600	700	Sumproduct
Profit	1200	1500	1600	Sumproduct

How to achieve this? Thanks!

TA

[Nathaniel_C]

This is posted twice