Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a D-growth chart.
It means, If my target value is 10 and sales is 6 and dimension is products.
want to draw a bar chart where dimension will be products name and in expression there would be my D-growth calculation (Those product will be displayed which are behind the target)
I use this formula:
=if(sum(ExtInvMisc)<sum(TargetAmount),ColumnName)
but its not working.
Thanks in advance
Thanks to all......I did it..
Below expression works as i want;
=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))
Can you try this?
=if(sum({<ExtInvMisc = {"=Sum(ExtInvMisc)=10"}>} ExtInvMisc)<sum({<TargetAmount = {"=Sum(TargetAmount)=6"}>} TargetAmount),ColumnName)
Or
If(Sum(Sales) = 6 and Sum(target) = 10. Column)
Can you share your data in excel format?
Thanks to all......I did it..
Below expression works as i want;
=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))
=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))