Pivot table

[Anonymous]

Hello

I have table like

Yr, Value

2014, 100

2013, 200

2012, 300

2011, 100

i want to create pivot table that has show only 2014 and 2013

like

Year       Amt

2014       100

2013       200

regards

ramu

[PrashantSangle]

Hi,

Use calculated Dimension

like

if(wildmatch(Year,'2014','2013'),Year)

And select Supress Null Value in Dimension

And take Amt as Expression

Regards

[ashfaq_haseeb]

Try like this

load * Inline

[

Yr, Value

2014, 100

2013, 200

2012, 300

2011, 100

] Where Yr>=2013;

Regards

ASHFAQ

[#4]

Add year in the dimension and use set analysis in the expression to get the desired output.

Expression:

Sum({<Year={'2013','2014'}>}Value)

[Anonymous]

Hi ,

Please find Solution below.

[Anonymous]

Thanks sampath

I also have another dim column to group the table. if I make the year field drag to column level I am getting message that "Allocated memory exceed". Can you please help me on this.

regards

ramu

[Anonymous]

Thanks sampath

I also have another dim column to group the table. if I make the year field drag to column level I am getting message that "Allocated memory exceed". Can you please help me on this.

regards

ramu