1 of 1 people found this helpful
I read your post a couple of times and I'm wondering if building a parameter would help you?
Perhaps building a parameter where you can view different scenarios of your costs?
It's difficult to understand completely without an example, but I think this may help.
Hope I'm understanding your question correctly.
A little difficult without seeing you twbx workbook - it raises a question of how to connect the data
I think I would create a data scaffold - just a consecutive list of dates that spans the date range of the data -
so all the data could be in a common date dimension I would join each data set to the scaffold (I am assuming that the dates in the 3 data sets do not align with each other)
the daa scaffold would be used as the data filter and for date calculations and the formula you use above SUM(X)+SUM(Y)+SUM(Z)+SUM(A)
could be used in the viz
a lot would depend on the structure of the data and the data sources
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you very much for your help. I cannot share my workbook because it contains company information and I cannot post online but don't worry John's answer was exactly what I needed.
Thank you very much! This is exactly what I needed!! You have made my life a lot easier