I'm looking for the structure below on my sheet (crosstab)
Calendar Year 2009
Calendar Year 2010
My raw data structure is like
so if I use a straight table with SUM for Rev I 'm not able to get cross tab structure as above, please suggest how that can be achieved aprt from pivot as pivot will also show me but in vertical direction.
is it possible from object properties only or do I need to change the raw data structure using transformation. if I can do from object property that be great as change in structure could loss my other elements in dashboard.