I have a Pivot table, where I am using alternate state for Actual to Actual comparison for year and month on the selection of Period 1 and Period 2 basis. It is working fine, but in the pivot table there is 3 countries A/C name. On the selection of Period 1 and Period 2 it is working fine but, It is displaying entire countries A/C name.
I want when I will select country individually; It should be display on the behalf of country selection also. As per my Second Pivot table.
For more ref. I have attached the qvw file, Please find the attached qvw.
