Custom Tabl chart

[alec1982]

Hi Guys,

I have a data source that looks like:

State            Year           HC

NY               2013          2000

NY               2014          1500

NY               2015          1800

Atlanta         2013          4000

Atlanta         2014          1500

Atlanta         2015           2000

How can I make a table chart to show as follow:

State          2013             2014          2015

NY             2000             1500          1800

Atlanta       4000             1500           2000

I would appreciate it if we can do that in the script as i want to add more calculated fields such as Varience between years and percentage.

Thxs,

Alec

[shree909]

hi use the cross table function when loading the data from the datasource...

[alec1982]

I know that can be done through a Generic load but not sure how to do that1

Thxs

[alec1982]

Hi,

The cross table doesn't work here! what I am trying to do is the oposite of the cross table

[alec1982 · Accepted solution]

Hi,

I figured it out

Table2:

Generic Load *

Resident table1;

[MayilVahanan]

HI

Generic

Load * Inline

[

State,Year,HC

NY,   2013,2000

NY,   2014,1500

NY,   2015,1800

Atlanta,2013,4000

Atlanta,2014,1500

Atlanta,2015,2000

];

[nagaiank]

You may load data (as the data source has it) in a table with three fields (State, Year, and HC).

You can display the data as desired by you using a pivot table chart with State and Year as dimensions. The year dimension can be made to appear on the top by drag and drop on the pivot table.

With the same table structure, you can define other calculated fields (variance, percentage, etc.) using set analysis expressions.