I am using Tableau desktopn and i have a following query.
I need to create a variable and further use that variable for different computation.Below is an example.
I have a database with following columns
Region Division Date Spends
A1 D1 d1 10
A1 D2 d1 20
A2 D1 d1 10
A2 D2 d1 20
Now i need to create a variable(Avg_spends) which is average of spends across different regions which i am able to do using "Create Calculated field" and my data now looks like this
Division Date Avg_Spends
D1 d1 10
D2 d1 20
Now if i need to roll this data up to division level and see spends across all division, i want to take the sum of Avg_spends and the resulting data should be
Now if i try to create this last table in tableau, answer i am getting is
Apologies if this is something very basic as i am new to this tool.
Many thanks in advance.
This is doable using Table Calculations. If you can post a packaged workbook, we can help you get the results you want. You could mock one up using the sample data provided, and post here as a .TWBX (packaged workbook) file. Cheers!