Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data like below table in which i am showing Region wise Total Visits done on a store by ABM. Now suppose i have 3 KPIs : Inventory Support , Price Drop Module, Demo Validation . It shows count of stores that have filled these modules respectively.
Query : I need to create a 3rd KPI : Total Activities which will show count of Modules/KPIs filled (Inventory Support, Price Drop Module, Demo Validation) . So max value will be 3 and min will be 0. Is there any function which can be used for this in chart instead of using nested if else.
Region | Total Visits Done | Inventory Support | Price Drop Module | Demo Validation | Total Activities Done |
East | 105 | 5 | 0 | 0 | 1 |
West | 200 | 3 | 4 | 5 | 3 |
North | 300 | 2 | 3 | 0 | 2 |
South | 98 | 0 | 0 | 0 | 0 |
I have got the solution of this :
=Rangemin(Column 1, 1) + Rangemin(Column 2, 1) + Rangemin(Column 3, 1).
I have got the solution of this :
=Rangemin(Column 1, 1) + Rangemin(Column 2, 1) + Rangemin(Column 3, 1).