5 minute solutions are often the best!
Thank you. I managed to integrate the function into my more complex production workbook.
I'm not sure I really understand how applying the formula...
if attr([Area])==[PARAM Area] then index() end
...as a filter works??? My understanding was that filters happen before calculation (still learning here).
Just a note to other users, when adding the calculated field to the filter, the lower value on the range may need resetting to 1 if the current parameter value is anything other than the first value.
1 of 1 people found this helpful
table calculations are little different. In this case index() creates row ID after normal filters have been applied and then that formula selects those rows where Area=parameter value. So it doesn't affect on calculations, it just takes some rows away from the viz.
I recommend you to take a look at Jonathan Drummey 's blog when you have time Want to Learn Table Calculations? Here’s How! | Drawing with Numbers
Thanks for the clarification Ville,
I'd come across that link before, but not explored in depth. I really need to sit down and work through it sequentially.