-
1. Re: Dynamic quick filter & conditional sum
Vishal D Aug 8, 2016 9:11 AM (in response to Vishal D)Any help would be appreciated?
-
2. Re: Dynamic quick filter & conditional sum
Hope Stiles Aug 8, 2016 10:16 AM (in response to Vishal D)If you are posting the workbook to Server for people to use, just set the Report Year Filter to 2016 when you publish it. That way when they open the workbook it will default to that. They would have to change it to see any other year.
-Hope
-
3. Re: Dynamic quick filter & conditional sum
Hope Stiles Aug 8, 2016 10:16 AM (in response to Vishal D)Also found this post which shows hot to change the Report Year to descending in the Quick Filter.
Can I sort the entries on a Quick Filter card in descending order?
-Hope
-
4. Re: Dynamic quick filter & conditional sum
Vishal D Aug 8, 2016 11:00 AM (in response to Hope Stiles)If I save it to 2016 and publish then what happens when we enter in 2017 and the database returns 2017 as value for that filter?
Also any idea how I can achieve this - 1. I want to show 'sales' at each state in tooltip by different codes. e.g sales for total 'xyz' = 1234 at sates TX and sales for 'ABC' = 456 at same state TX in toolip - how do I achieve this?
-
5. Re: Dynamic quick filter & conditional sum
Vishal D Aug 8, 2016 1:28 PM (in response to Vishal D)I tried IF [Codes] = 'XYZ' THEN [Sales] END this gives me all sales for all 'XYZ'
I want to combine sales of 'XYZ' & 'ABC', how do I modify this calculated field to give me total sales for 'XYZ' & 'ABC'?
-
6. Re: Dynamic quick filter & conditional sum
Hope Stiles Aug 9, 2016 5:57 AM (in response to Vishal D)I am able to get the sales for just ABC and xyz with this formula:
IF [Codes]="ABC" or [Codes]="xyz" THEN [Sales]END
-
7. Re: Dynamic quick filter & conditional sum
Hope Stiles Aug 9, 2016 5:58 AM (in response to Vishal D)I suppose when 2017 started, you would have to edit the published workbook to have 2017 chosen in the filter. Not ideal to have manual changes. Perhaps someone else will know a way to get it to default to the current year.
-
8. Re: Dynamic quick filter & conditional sum
Vishal D Aug 9, 2016 7:22 AM (in response to Hope Stiles)I dont think I want to update the workbook each year, rest of my life
Need more dynamic solution to handle 'Report Year'
Thanks for your help on other 2 things.