You'll have to have all the values on one sheet. We don't pass values like that between sheets.
I notice that you use single-select filters (or "All") on the filters that are specific to the two sheets, and that can be to your advantage. If you were to make parameters instead of filters, you could have both sets of selections function within the same sheet.
In the attached I created a parameter called [Build2 Parameter]. I loaded it from [Build] so it contains all the values. Then I added one more value "All". Next I created a calc [Avg IOPS B2] that grabs [Avg IOPS] values based on the selection from the parameter. You could use that new calc on your B1 sheet, and then you would be able to do your math in sheet 1. (You would need to do the same for [TestDate2], [TestDate1] and [Build 1].
PercentageDiff_v10.4.twbx 86.4 KB
Vimal, why do you have these in two different sheets? They're both coming from the same data source, correct?
Instead of creating two different sheets with different filters, you need to create two calculated fields and specify your filters in the calculated field.
This way you'll have two measures that can be displayed in the same sheet. Then create a third calculated field that is the percent difference between your first two. Again, all in the same sheet.
Hi Mike Mainzer,
Yes, you are correct. I'm happy If i get it in this way.
Instead of creating two different sheets with different filters, you need to create two calculated fields and specify your filters in the calculated field. -- > how to do this, Could you please help me?