Hi All,
I am trying to calculate brand-wise scores. Please refer attached excel file -
> The blue fields show data that I have. The orange ones are the ones I need to replicate in Tableau.
> Objective: To find the sum if it belongs to the brand in the mentioned row (sum-if). The sum-if for a brand should should change if I un-check a category filter. (**I will then normalize this score and average it with previous score to get future score.)
> What I could do till now: Ref. attached Tableau file - I created a 'sumif_brandwise_calc field' calculated field using {Fixed Brand: Sum(score) } . This gives me the sum-if results. The problem is - when I un-check a category , the Sum-if value remains same. For eg. Ideally I want the sum-if for brand 'A' to change from 94 to 62 if I uncheck detergent. But that is not happening. Please help with alternate solutions.
Thanks.
This might be an easy fix. Just click on the [Category] filter and 'Add to Context'. This ensures the filter happens before the LOD.
This article talks about the order of operations in further detail: Tableau's Order of Operations