Hello again - I'm still in the midst of learning your product.
Today I am trying to create what I know in Excel and Access as a pivot table report. I created a view that has three columns: Top (Containing city names), Left (people), and Total Money (Sum of money where Top and Left intersect) - The query seems fine and creates appropriate totals. I'd like to create an output looking like the following:
Munich Berlin Dresden Leipzig TOTAL
Anna 200 0 300 100 600
Mary 20 20 20 20 80
Brigitte 0 1 0 0 1
Jon 10 4 4 0 18
TOTAL 230 25 324 120 699
I tried pulling in a table but I'm only able to get a two column listed output like
Anna
Munich 200
Dresden 300
Leipzig 100
etc which wastes a lot of paper. Any ideas on how to make a pivot table?
Thanks!
Andy
Hello Andy,
Currently, the number of columns you can display in a table must be known at design time. In this example, it would mean that you know beforehand which cities there are to display. If that’s the case, you can implement this scenario using a table. Then, you can add a summary row at the end of the table where you write expressions for calculating the totals.
For a variable number of columns, the case is not directly supported by Reporting yet. This scenario is in our backlog.
Regards,
Luis
Thanks for your reply Luis!
I've created the table headings of my cities (hard coded them with the names for now). How do I get the name on the left side of the table and what do I put in the cells under each city so that the correct name and correct amount falls under the correct city (keeping in ind that some intersections will be 0)?
(I promise to bug you next on how to get the totals to the right and at the bottom but want to walk before I run first!)