You can try:
(YEAR(DATE1) = 2017
YEAR(DATE2) = 2017
YEAR(DATE3) = 2017)
drop that on filer shelf and select 'true'
You can replace the 2017 above with a parameter.
Call it 'Year of Date'.
Then change the calc above to
(YEAR(DATE1) = [Year of Date]
YEAR(DATE2) = [Year of Date]
YEAR(DATE3) = [Year of Date])
Drop calc on filter shelf -> filter to 'true'.
then show parameter. Now you can look at different years if needed.
Create calculated field as following and place it on filter pane and select 'True'.
YEAR([Date1]) = 2017
and so on
Thank you everybody! I'll try this solution this night!
Have a nice day everybody!
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hello Community! Thank you for the help.
I've tried the answer and it work well, but the datas aren't correct: The use of "OR" involve a over-representation and the use of "AND" involve an under representation of the data.
So, maybe you'll have the answer of that question:
I've 3 different sheets, which one using a filter based on one date (Date 1 for sheet 1, Date 2 for sheet 2, Date 3 for sheet 3). I'm trying to write a calculated field which will be like this but I don't know if it exist. In fact, I'd like to select the filter according to the sheet and put the parameter on my dashboard to avoid the use of 3 filters (Date1,Date2,Date3) and have only one (YEAR).
IF SHEET = SHEET1 THEN DATE1 = [YEAR]
ELSEIF SHEET = SHEET2 THEN DATE2 = [YEAR]
ELSEIF SHEET = SHEET3 THEN DATE3 = [YEAR]
[YEAR] is the parameter defined by John Croft 3 days ago!
Thank you for your time everybody!
1 of 1 people found this helpful
Keeping Year as your parameter, define 3 calculated fields:
Sheet 1 Calc:
[YEAR] = YEAR([DATE1])
Sheet 2 Calc:
[YEAR] = YEAR([DATE2])
Sheet 3 Calc:
[YEAR] = YEAR([DATE3])
For each Sheet, drag the appropriate calc to the filter shelf and filter to 'true'. Now each time you change the parameter you should obtain the appropriate representation on each sheet.
Let me know if that does not work.
After short time, I've found the answer!
Have a nice day