@hipsterVizNinja - this is what I was after. I was stuck on how I could use table calculation with a limited view. This helped me out heaps, many thanks for sharing your knowledge. Also, when I am trying to use percentage difference table calc, the view introduces null values instead of 0. Can you please suggest workaround that?
🎉
Thank you for the explanation about the use of first(), last(), index() and size() 🙂
@hipsterVizNinja - this is what I was after. I was stuck on how I could use table calculation with a limited view. This helped me out heaps, many thanks for sharing your knowledge.
Also, when I am trying to use percentage difference table calc, the view introduces null values instead of 0. Can you please suggest workaround that?