Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i need a table with the data displayed in this form (Months in column, year with values and percentages):
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2014 | v | v | v | v | v | v | v | v | v | v | v | v |
2015 | w | w | w | w | w | w | w | w | w | w | w | w |
Delta % | y | y | y | y | y | y | y | y | y | y | y | y |
I have noticed that with simple not pivot table the datas are displayed in column.
What have i to do to obtain a this result?
Thanks
Marco
Try making your years and delta as expressions, with month as a dimension. Then, on the presentation tab of the properties, check 'Horizontal'
Mike
Is it possible to obtain this by using the year filed in the dimension section and use the sum field to obtain the result i expect?
Thanks
Marco