Hi:
I have a rows containing names of medicines. I have three different columns of dates, with respective different columns containing quantity relative to the date as below.
Name of medicine Qty1 Date1 Qty2 Date2 Qty3 Date3
I want to generate a pivot report consolidating all 3 dates (C, E, F) in a single column, which then displays name of medicine and quantity1 or quantity2 or quantity3 relative to that date. I have used slicers, but they are all different dates. Can I somehow consolidate all three date columns into a single column - either through slicer or pivot table field? Thanks for the help.
I have a rows containing names of medicines. I have three different columns of dates, with respective different columns containing quantity relative to the date as below.
A B C D E F G
I want to generate a pivot report consolidating all 3 dates (C, E, F) in a single column, which then displays name of medicine and quantity1 or quantity2 or quantity3 relative to that date. I have used slicers, but they are all different dates. Can I somehow consolidate all three date columns into a single column - either through slicer or pivot table field? Thanks for the help.