Forum Discussion
Date sensitive pivot table
I need to make a pivot table with this data: I need to have column A witch is the name of projects as columns, and i need to have CAPEX as values, but here is the tricky part, this values n...
RaulCozma Can you share an Excel file with the start file and the intended result? Why can't you just put the year of the date field as a column?
the problem was that i had 3 columns with dates, and depending on the date i need i certain column (exemle. if the date in the column g is 2024 i need the number from c, if the date is 2025 i need the number from d) but i rezolve that with an if function, i could't make this with pivot unfortunately.
