Thanks a ton for taking out time for this.
But this is not the output I am expecting.
I am using this expression to make first report:
=If(Rank(max([DAT Version (VirusScan Enterprise)])) <=3 , [DAT Version (VirusScan Enterprise)])
and restricting top 5 values of DAT Version in dimension limits(FOR WORKSTATION) but that not able to merge server data in this.
PFB: EXPECTED OUTPUT
The above table should also contain 3 more rows with top 3 DAT Version for server as well for each date.
And the rest of the data should be there in other excel.
That's how I have to make 2 separate reports.
Hope you understand.