0

I have this Pivot Table, and what I need to do is: Filter this data and show only those records whose date (3rd column) is equal to its parent date (2nd column) or just 1 day difference is there.

And then I have to put conditional formatting on the values (Columns after 3rd column) based on 'If both dates are same and the value lies in particular column'

How to do that? Currently I have to do it manually, so looking for a solution if anyone could help. Thanks in advance

ScreenShot of Pivot Table

Improve this question
5
  • You can do the filtering with helper column in the original range (=ABS(ChildDate - ParentDate)<=1). Regarding conditional formatting, your question isn't clear please specify what you exactly want to achieve.
    – Máté Juhász
    Oct 5, 2015 at 6:36
  • The parent date is not mentioned in the same row, it's mentioned many rows above the child row....
    – TheSarfaraz
    Oct 5, 2015 at 6:37
  • I meant helper column in the source of the pivot table.
    – Máté Juhász
    Oct 5, 2015 at 6:50
  • Oh...Actually, there are multiple Pivot Tables from the same source data so I'm looking if I can do directly from the Pivot Table without messing up the source data
    – TheSarfaraz
    Oct 5, 2015 at 6:51
  • No, you can't do it in the pivot. Actually it doesn't change anything in the source data, just add a new column, so it shouldn't be a problem.
    – Máté Juhász
    Oct 5, 2015 at 8:14

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .