Bar chart With Two dimension

[#1]

Hi All,

I want to create a bar chart with 2 dimension & two expression. One expression should be stacked sub type & other expression should be grouped subtype.

Any help would be appreciated.

[#2]

PFA contains the application as well as data..

[#3]

This Chart is OK but my requirement is different

I have:

1)Annual plan year wise for salesman

2)Actual Plan month wise for salesman

I want All month grouped into a single bar & another bar for Annual Plan

[#4]

Could you please add your application sample to understand me your requirement.

[#5]

PFA content.

I want both the chart to be combine.

[#6]

Any solution guys???

[Anonymous]

Hi,

See attachment.

[jagan]

Hi Prashant,

Try like this

Script:

----------

Tab1:

LOAD Salesman,

     Month,

     Actual AS Value,

     1 AS Category

FROM

[Budget.xlsx]

(ooxml, embedded labels, table is Sheet1);

Tab1:

LOAD Salesman,

     Month,

     [Annual Plan] AS Value,

     2 AS Category

FROM

[Budget.xlsx]

(ooxml, embedded labels, table is Sheet1);

Now in chart use

Dimension : Salesman, Category

Expression1:=Sum({<Category={2}>}Actual)

Expression2:=sum({$<Category={1}, Month={Jan}>} Actual)

Expression3:=sum({$<Category={1}, Month={Feb}>} Actual)

Expression4:=sum({$<Category={1}, Month={Mar}>} Actual)

Expression5:=sum({$<Category={1}, Month={Apr}>} Actual)

Hope this helps you.

Regards,

Jagan.