Expression Help

[sona_sa]

Hi All,

1. I have a scenario like -> In Sheet 1 à I select project à Project à XMM7560, Year à 2018, Month à Jun

Data is displaying –

Country	Location	Violation Status
Canada	San Diego	No Violation

Now I go to Sheet 2, Where I have triggered on sheet active – Clear All

So all selction goes on.

There is 1 Table box and 1 Pivot there, where in Table I want to see all data in Table box and In Pivot I want to see

Country	Location	Violation Status
Canada	San Diego	No Violation

But It is displaying all data for Pivot

Please find the attached qvw for reference. Please share some idea How I can do the same.

Regards,

Kumar

[sunny_talwar]

TEST2 tab doesn't have any pivot table... all I see if 3 list boxes and a table box...

[sona_sa]

Yes Sunny,

In table box I want all data in Table box but I need that Pivot Table whatever the data is displaying in Test 1 sheet.

Please find the attached file.

[sunny_talwar]

May be use alternate state and put your table box in an alternate state and plus remove the trigger to clear all

[sona_sa]

Hi Sunny,

Sorry I need only Canada data in table box. Without any selection. In case if there is no any list box is not available.

If u will check the data - One is normal country and another one Country_metadb,

So I am selecting in test1 it should to effect in same here for country_metadb.

Hope u got my point.