I have a table with various KPI's. In the first Columne I have a dynamic group called BP.
This dynamich group contains: 1) BP Headquater, 2) BP Group, 3) BP Outlet/Store
To have an better overview its necessary to have also City in the table, as many customers have several outlets within a country, but they have only 1 headquater. So I need the City information for my Outlet view, but not for the Group or Headquater View.
So, when I select "Headquater" in my dynamic group, City should be hidden, otherwise I see Total city and not customers headquater.
How can I implement this?
I tried to do this with an if formular, but unfortunately I'm not a developer 😞
Thanks for your help,
It is the full formula, as this is a conditional field QV expects a true false condition, no need to write the if. And Maybe Sunny is right and it needs to be
GetCurrentField(BP) = 'BP Outlet/Store'