use this Filter for Version:
Thanks buddy. that solves one part of the issue . say if i bring quarter before the month and use subtotals.
The subtotal is not working properly. Any suggestions
I need to see workbook.
LOOKUP only works with the dimension values that are filtered, you know that already
To return something outside that range you need to create a more complex calculated field. You can still do what you want to do, there's just a touch more effort involved.
It's hard to show you exactly how to do it without knowing how your data is structured though, can you create a small demo/dummy workbook and upload here please ?