I use the table view with grouping and aggreg...

ux
(Yossi Oulu) #1

I use the table view with grouping and aggregate value to zoom into budget. It is nice that the user can drill down and see the aggregated value of the budget$. But, I would like to show another aggregated value, the actual expenses$ for the same zoom in level. The problem is that the aggregate allows me to choose only one field (e.g. or sum(budget$) or sum(expenses$) while I need both)

  1. Is there a plan to allow a second/third aggregation field? 2. Is there a way to achive this behaviour in a different way? E.g. with dashboard, somehow getting the zooming selections of the user done in one view while presenting a totals row (e.g. buget$, expense$) in the other view

Thanks

(Levent KULAÇOĞLU) #2

@Yossi_Oulu

You can create a VC and concatenate fields as per your need and then pivot/group as per this VC

(Yossi Oulu) #3

Thanks. Not sure we are talking about the same thing. There is an option to select Group Aggregate: see image. This allows me to select only one field to apply the SUM on. I cannot apply it on concatenated fields. And the only way the user can see that total after each zoom in click is by using this aggregate function. If the aggregate could have multi fields setup I could select: 1. SUM:: Budget$ 2. SUM:: Expenses$ This aggregation sum appears in each selection of the drill down as the sum of the current filtered data If you think there is a way to implement that I will be happy to hear

(Praveen Seshadri (AppSheet)) #4

We intend to add multiple aggregate functions. It is coming very soon. @Morgan_Dixon_AppShee

(Yossi Oulu) #5

@praveen good. Thanks