Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use calculated Dimension
like
if(wildmatch(Year,'2014','2013'),Year)
And select Supress Null Value in Dimension
And take Amt as Expression
Regards
Try like this
load * Inline
[
Yr, Value
2014, 100
2013, 200
2012, 300
2011, 100
] Where Yr>=2013;
Regards
ASHFAQ
Add year in the dimension and use set analysis in the expression to get the desired output.
Expression:
Sum({<Year={'2013','2014'}>}Value)
Hi ,
Please find Solution below.
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
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