Hello everybody, I have a question. I am new to this, hard as I tried I cannot figure out the solution to a problem that seems so simple.
I would like to get a sliced view of a table based on a filter with multiple selection.
This should give an idea of what I’m trying to do:
–DOCUMENT NAME----> Products
–1ST SHEET NAME----> Cars
–HEADERS----> Car,Red,Blue,White,Grey
–ROWS----> Punto,No,No,Yes,No
GT40,No,No,No,Yes
EN-V,Yes,No,No,No
Reliant Robin,Yes,No,No,No
–2ND SHEET NAME----> Filter
–Filter columns----> Red,Blue,White,Grey,Filter Data (Yes/No Type)
For example, if the user doesn’t like Red and White cars, by clicking on Red and White in the Filter view the outcome will be the content of “Cars” minus the rows where Red’s and White’s value is “Yes”. Expected result: GT40
The last failure was this formula, set in the “FORMULA” field of the Filter Data column:
SELECT(Products[Cars],[Red]<>[_THIS].[Red])+SELECT(Products[Cars],[Blue]<>[_THIS].[Blue])+SELECT(Products[Cars],[White]<>[_THIS].[White])+SELECT(Products[Cars],[Grey]<>[_THIS].[Grey])
I thought using an enumlist would be the perfect choice, couldn’t make it work (“Cannot compare Text with List”). Slices and column formulas, only one setting works.
I cannot use USER_SETTINGS because the complete table has more than 10 parameters, and the Syncing process slows things down.
Could someone please tell me how to proceed?
LinkedIn
Twitter
