Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can display data by year by using the following code: '=SUM({<year = {2010} >}amount).' I insert this code as an expression which gives me the year as a column-header. Pretty slick. Is it possible to add an additional level of granularity such as type? I would like to retain the year as a column-header with type A and B below. Thank you in advance for your assistance.
Don the Intern
Use pivot table
Year,type as dimensions
Sum(amount) as Expression
Drag year and type to the top
You are correct, but that does not really utilize 'set analysis.'