Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need the value from the beginning of each year in a pivot table.
2023 | 2024 | 2025 | |
Employess |
Previously, this value was shown individually for a selected year. But now I have to display these values in a table for each year.
Count([MASTER_CAL.Date] = {"$(=Yearstart(AddYears(Max(MASTER_CAL.Date),0)))"}>} distinct [Abtn.ANNr])
Of course I can't use this expression anymore.
Can you help me please?
Thanks for your suggested solution.
I can't use it in the script because the required data isn't together in one table.
But I found another solution.
Count({<MASTER_CAL.Date = {"=Left(Date(MASTER_CAL.Date ), 6)='01.01.'"}>} distinct [Abtn.ANNr])
Hello,
In your place I would use the script.
You can create a DateYearStart field like this:
if([MASTER_CAL.Date]=YearStart([MASTER_CAL.Date]),[MASTER_CAL.Date]) as DateYearStart
Then I will use the DateYearStart field as a dimension
Thanks for your suggested solution.
I can't use it in the script because the required data isn't together in one table.
But I found another solution.
Count({<MASTER_CAL.Date = {"=Left(Date(MASTER_CAL.Date ), 6)='01.01.'"}>} distinct [Abtn.ANNr])