Hi all,
Really want to thank the community for all its help on my last question - this is an extension of my last query and I'm hoping this one will have a workaround of sorts.
Let's say you have this table, with values tagged to certain types of projects. What I want to do is create a calculated field that represents the difference between the total value for Project A against each of the total values associated with Projects B and C.
Project Name
Value
Project A3Project B5Project C4Project C2Project A10Project A5Project B3Project B4
I know you can do this by manually creating groups in Tableau (Sum of Project A = IF [project name] = "Project A" then sum([VAR]), Sum of Project B = if [project name] = "Project B" then sum([VAR]), etc.) and finding the difference that way, but I want this to be dynamic because in my actual file I have dozens of project titles to compare against Project A. I also know now that you can create a set and use the quick calculation feature to display this in a chart, however I'm looking to capture this value in a measure because I want to use these values in other calculations.
I've attached a simple workbook for your convenience. Thank you all so much in advance!
Hi Isabel,
I hope you are expecting below
Attached the workbook same, i created parameter where you can compare with any Project , if especially you want to compare only with A then remove the parameter place "A" it will do the trick
Hope this helps
Plz mark this answer as correct or helpful to close the thread
BR,
NB
