Forum Discussion
Create slicer for multiple columns
Is it possible to create a slicer which looks at multiple columns? I have a table (Normal table, this cannot be a pivot table) which includes suppliers, and then order days in columns split by weekda...
Thanks a lot for your response. I have not used power query before so it is interesting to see it's use. I created a macro to do something similar with all the days in one column.
Unfortunately, I can't have duplicate lines for each supplier in the main table because it contains for example order quantities, which I do not want to be duplicated. So I need the filter to be applied to the original table. Do you have any ideas? Or perhaps this is not possible
Unfortunately, I can't have duplicate lines for each supplier in the main table because it contains for example order quantities, which I do not want to be duplicated. So I need the filter to be applied to the original table. Do you have any ideas? Or perhaps this is not possible
Rachel1994 Not much is impossible with Excel. But I don't really understand why can't you use pivot tables, provided you structure the data correctly. That for you to decide, of course. But data how you have it now is difficult to analyze. That's why I used PQ to improve on that.
And I don't understand either why having duplicate supplier codes in a tabular transactions table would cause a problem. It's not very difficult to determine that you had 8 transaction this week with 6 distinct suppliers.
But having said all that, you mentioned to be working on a larger macro driven project (programmable). Since I'm not a big fan of macro's, I perhaps don't really understand what you are trying to achieve an why you insist on using macro's.