- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trigger Issue
Hi.
I have a Trigger issue within the Sheet Properties for the attached Document, if you click on each sheet the trigger will select the relevant Type as per the named sheet.
But if you click on "Archive" sheet and select Year = "2011" then go back to the Sheet "Sales" the Type field gets removed?
Which will cause confusion for the user as the sheet should be locked to type = "Sales"
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The selection on Type fails as there are no Sales for the year 2011 in your example. A solution could be to do a (unlock and) clear all before selecting the desired selections for each sheet
Edit (See attached example)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sheet = "Sales" does not have a corresponding Year = "2011" value. So what is happening is the following:
a) Everything gets locked (including Year = "2011")
b) Sheet gets unlocked and clear (Archive is deselected)
c) You are trying to select Sheet = "Sales" but it's excluded, because there is no Sales for Year = "2011", therefore your selection is NOT made.
d) You unlock everything
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes because, In 2011 you don't have any Sale data.
If you select 2012 or 2013 from archive sheet and go to Sale, you will definitely get year and type field selected.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The data doesn't have any rows where Type=Sale when Year=2011.
So when you activate the ''Sales' sheet and lock all the fields (with Year=2011) and then try to 'select in field' on 'Sale' it doesn't work because Year=2011 is locked and you can't have two filters that show opposite data. That is for better or worse how the associative model works.
I think you could resolve this by loading dummy 0 values as placeholders...so add this to the data for example:
Sale, 1, 0, 0, 0, 2011
...but that seems like a lot of work especially with lots of dimensions.
Consider using SET ANALYSIS (not available in table boxes) as a way of hard filtering anything on the chart to Type='Sale' or 'Archive' depending.