Bar Chart

[krishna20]

Hi Friends,

I'm having two fields TP_Year and BD_Year. The two years are from different tables. Actuals is the amount from policy table based on TP_Year and Budget is the amount from budget table. I need to show Sum(Actual) and Sum (Budget) in a single bar chart.

Here the years are different. Even though policy and budget table linked together,the year fields are different. I need to compare the both the amounts in a single chart.How it could be done? ! Please anyone suggest me.

Regards

Krishna

[sunny_talwar]

You can disregard both TP_Year and BD_Year and use ValueList() function to create years for your specific chart and then then use if statements to create your bar chart. The exact dynamics may have to looked into further, but I have used this approach lately.

HTH

Best,

Sunny

[PrashantSangle]

Hi,

Concate both table try like

load TP_Year as Year,

Actuals

from Policy_Table;

Concatenate

load BD_Year as Year,

Budget

from Budget_Table;

Regards

[krishna20]

Hi Max,

In Bud_Year there is only two years.In TP_year there is years from 1995 to 2015.

Is we will get expected output by concatenating two tables?

[PrashantSangle]

Hi,

Try it, If not work then let me know.

Regards

[krishna20]

Hi Max,

This Approach Doesn't works.

Please give me any other suggestion.

[krishna20]

Hi,

Can you please give me an example  using valuelist() how to do it.

[#8]

do you have sample data that you can share?

Depending on your data model and the base year you want to use you could join the field into the parent table.

Regards

Rahul 

[krishna20]

Hi,

As much as data reduced and attaching sample file. Pls suggest on me this.

[sunny_talwar]

Please find attached the example using value list as well as using a inline table.

Although tedious it can give you what you seek.

HTH

Best,

Sunny