Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have two columns in my straight table, call it C1 and C2.
C1 contain the formula SUM(A) / SUM(A)+SUM(B). C1 calculate the percentage total.
C2 contain the same formula, SUM(A) / SUM(A)+SUM(B). However, I want C2 to calculate the percentage of "House Type", which I have created a filter pane in the app.
Obviously, when I select the "House Type" in my filter pane, both C1 and C2 will calculate and change to the same results.
I need C2 to only perform aggregation if I select the "House Type" from my filter pane, while C1 will remain the same.
How can I achieve this?
Hi
In order to ignore the filter, you can use set analysis
SUM({<Field1=>}A) / (SUM({<Field1=>}A)+SUM({<Field1=>}B))
Hi
In order to ignore the filter, you can use set analysis
SUM({<Field1=>}A) / (SUM({<Field1=>}A)+SUM({<Field1=>}B))
Hi Mayil,
What if my formula is this:
SUM({<Field1="bb"}A) / (SUM({<Field1="bb"}A)+SUM({<Field1=bb"}B))
My "House Type" is Field2. How can I add Field2 into the above?
Hi
Try like below
SUM({<Field1={"bb"}, Field2=>}A) / (SUM({<Field1={"bb"}, Field2=>}A)+SUM({<Field1={"bb"}, Field2=>}B))
Hi Mayil,
Could you explain what Field2= does? Thank you.
Hi
Field2= , its ignore the selections made in Field 2.