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...
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.
