I've been trying to make this happen but I can't seem to get it right.
I have a long table from row 16 (3,000+ lines) and I want to filter out the data by using slicers. The small table from B2 to H9 is what I want to make into a slicer. I tried making a pivot but it's calculating the total figures.
Can anyone tell me how I can put slicers on top of this Excel sheet so that the list below gets filtered in real time as and when I select a combination from the slicers. I want to place 7 slicers to filter data because I basically need to lookup the value in Column O (Price/ton) after I've entered a unique combination (generated from row 2 of column B - H).
Image: Screenshot by Lightshot
I have a long table from row 16 (3,000+ lines) and I want to filter out the data by using slicers. The small table from B2 to H9 is what I want to make into a slicer. I tried making a pivot but it's calculating the total figures.
Can anyone tell me how I can put slicers on top of this Excel sheet so that the list below gets filtered in real time as and when I select a combination from the slicers. I want to place 7 slicers to filter data because I basically need to lookup the value in Column O (Price/ton) after I've entered a unique combination (generated from row 2 of column B - H).
Image: Screenshot by Lightshot
