1 of 1 people found this helpful
Create three calculated fields
Create a dummy string calc field.
Drag all the calc fields in sheet1(total) as per below screenshot
Put your base data in second sheet(base data)
Create a dashboard drag base data first as tiled. Then you drag total sheet as flaoting. Hide the titles from both the sheets.
Hide the headers from total sheet
I hope this is your desired output
Thanks Mahfooj for taking the time to answer my question. I think you're answer is correct however if I have multiple regions or other dimensions to use aside from Region which is more than 50 items I guess it will be hard time adding individually the data values and the weighted average or Total values
if you found my answer helpful kindly mark as correct. So that this thread gets complete.