Filters are used to limit the data available in the table that underlays the worksheet
once the data is filtered out it is no longer available for use -
so what to do - you can use sets thied to parameters to have 2 data for 2 separate dates (or products) and then use the sets in your other calculations
similar to how you would use a filter
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.
Thanks for your reply Jim.
Can you please help me with one sample workbook . Currently i have created two parameters for Week selection First week and Second week and created the calculated filed for it as below
ZN(IF [First week]= [Week] THEN [Meter Reading] END)
ZN(IF [Second week]= [Week] THEN [Meter Reading] END)
Then created one more calculated field as below
(SUM([Second Week])-SUM([first week])) / SUM([first week])
to compare the meter reading in percentage now it showing the results.like below
there was not book attached
Please post your twbx workbook