Charts

[#1]

i want three expressions say Sum(Sales),Sum(Sales1) and Sum(Sales1) - Sum(Sales) and 1 dimension say salesperson .

i want to have Sum(Sales) and Sum(Sales1) should come as total for all the brand and Sum(Sales1) - sum(Sales) as per the brands in bar chart

I mean to say that sum(Sales) and Sum(Sales1) should not come for dimension but sum(Sales1) - sum(sales) should come for dimension in bar chart.

Please help

[deepakk]

hi Manish,

I hope the attach application helps you out.

Deepak

[#3]

hi deepak

thanks for your reply .. but i want only one bar for sum(Sales) on the left and another bar on the right for sum(amt)

and in between sum(sales) - sum(amt) for all the dimensions

[deepakk]

hi Manish,

I am not sure if you can do that in the same chart. But you have a work around by creating two charts.

I have attach a sample.

Deepak