I've data in the form attached(ques) & need output as attached(a pivot table)
The problem is that Year has dynamic values which can increase upto 'n' Columns & More cols are needed to be added to the pivot table which are independent of Year.
I think:
1) I've to use only one expression.
2) I can't use Year Dimension
I concatenated the data from two sources,the Typeid field distinguishes the concatenation which i added in the data to identify the sources
as you can see in the ques. that values for Year are blank for TYPEID=2 but still it has to be shown in the same chart with the Year Values(which suggests that year can't be used as dimension,unless you guys have other ideas).
Note that there is only 1 row for 2014....but it can be more,infact Year can increase....(2015 till....n depending on the data)
Is it also not possible to create a a table like this, without using Year as dimenison
& without using set analysis :sum({<Year={2013}>} Amount) as we don't know how many Years
does the Table have ?
Is there anyway we can count the distinct Years in the table and use some expression which will result in adding the cols 2015, 2016...and so on...dynamically as the Year values increase in the table.
May be Genric loading the table to make it a CrossTable and using.........???
