Hi folks,
I want to put a percentage of total in YValueExp by department (SerieExp = Departement) like this :
100 * (GrandTotal / DepartmentTotal)
My example :
100 * (Sum( [INVBALANCES.CURBAL] * [INVENTORY.STDCOST] )/
Sum( [INVBALANCES.CURBAL] * [INVENTORY.STDCOST] ) Group By [VW_USAGEITEM.DEPARTEMENT])
Can you please help me with this?
I want to put a percentage of total in YValueExp by department (SerieExp = Departement) like this :
100 * (GrandTotal / DepartmentTotal)
My example :
100 * (Sum( [INVBALANCES.CURBAL] * [INVENTORY.STDCOST] )/
Sum( [INVBALANCES.CURBAL] * [INVENTORY.STDCOST] ) Group By [VW_USAGEITEM.DEPARTEMENT])
Can you please help me with this?