Pivot table where each row has different calculation logic.

[priscilarubim]

Hi Community,

What is the best approach to build a P&L report as a pivot table in Qlik Cloud (columns: Actual / Budget / Prior Year) when each row follows a completely different calculation rule, without ending up with a single enormous measure expression?

In Crystal, each row was hardcoded with its own formula. In Qlik, I need to find a scalable way to handle this, ideally driven by a metadata/mapping table that defines each line's account range, formula type, and sign.

Has anyone tackled this pattern before?

Any examples or approaches are welcome. Thanks!