Hello,
I have a scenarion where I have divisions like 10 divisions with sme 200 products all the products are attached to some or the oter division we call it as base division but a single division can market other division products also so in a financila year suppose sme A division does a business of 1000 crores ,
I have to show it in a straight table or pivot table contribution of all the division towrds the total business suppose base division here is 900 crore rest is contribyted by pther division.
The expression to calculate the business i am using is
(SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Gross Sales Amount])
-
SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Return Amount])
-
fabs(SUM({$<[Is SRN]={0},
[GL Code]={"4000001","4000002","4000003","4000004","4000005","4000006","4000007","4000008","4000010","5000015","5000013","5000014","5000016"},
FiscalYear={$(=max(FiscalYear))}>} [Credit Note Amount]))
+
SUM({$<[GL Code]={"4000001","4000002","4000003","4000004","4000005","4000006","4000007","4000008","4000010","5000015","5000013","5000014","5000016"},
FiscalYear={$(=max(FiscalYear))}>} [Debit Note Amount]))
/100000
The expression is right but how do i show this scenarion in a chart or table???
Thanks and Regards,
Rohit Yadav