This content has been marked as final. Show 2 replies
Hello forum folks
I have created a table that divides my KPI into three categories: current, last year, last period. The last period and last year are percentage calculation of development between current and last year or last period.
My problem is, when i remove my measure in my Measure name filter, and add it again, Tableau forgets how to do the calculation in relation to compute using.
It should 'Compute using' my KPI Category, but after adding and removing it forgets.
I'm going to create this formula for every measure, and be able to add and remove measures without messing up the calculations.
Is there any way to force the calculation to ALWAYS compute using a certain field, or how can i solve this?
I have included a workbook.
Appreciate any help, thanks!