Hello,
In the example attached, I am trying to visualize the sum of Weighted Goal Index.
I managed to calculated the weighted number at individual store level based on their sizes but cant seem to find the way to add them up in the total row. (in the example, it would be 155 (97+58), not 160)
Any solutions would be much appreciated.
Jason
Hi Jason
you could add a new calculated field for overall weighted goal index as
window_sum([% Weight]*avg([Goal Index]))
that will give you an extra column where every record is the overall weighted average. Not quite the same thing but something to work with.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.