Allow multiple values as rows (not columns) or allow calc fields in Pivot Tables
Currently the only option for multiple values using one column field is to present the values as sums next to each other, which messes the appearance up and creates two sub-columns per column. Another fix would be allowing calculated/formula fields in Pivot Tables. This is a very basic request and I'm surprised it is not available.
As a simple example, if you're looking to create monthly financial statements where the Month Field is the column header and there are multiple values which belong to the column headers and are coming from another table's values, there is no way to present the data vertically. Screenshots attached of how it appears in Caspio vs. how it should be able to be visualized using the financial statement example.
Justin
shared this idea
-
Justin
commented
Let's vote this to the top!