How use aggregate formula form two table or use IF in Pivot view
I want use in aggregate formula from 2 table
But I have this info
Modified formula can be associated only to the table "Otwarte z filtrem - Support" and not to the existing table "Agents (Zoho Desk)".
Changing associated table is not allowed when editing a formula.
I have 2 table x and y
In aggregate formula i want create :
(((Table2.y / "sum table2.y") *100)/Table1.x) *100
Number in table1.x is dependent on "Owner Ticket "
I also have in table 2 "owner ticket" but if i want use
(((Table2.y / "sum table2.y") *100)/(if owner is xyz =20,10)) *100
i Have this
| Mixing of Aggregate functions (like SUM, MAX, ...) with non aggregate columns is not allowed. |
|