Calculate Growth

[Anonymous]

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

[Anil_Babu_Samineni]

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)

[isingh30]

Can you share your data in excel format?

[Anonymous · Accepted solution]

Thanks to all......I did it..

Below expression works as i want;

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))

[arvind1494]

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))