Forum Discussion
How to link a slicer simultaneously to both a PivotTable and a normal table
Doable, yes. But I don't know whether it is the best approach or whether it would be better to have a separate helper pivot table for each dimension.
= LET(
region?, BYROW(InputTable[Region] = UNIQUE(TOROW(rowLabels1, 3)), ORλ),
sector?, BYROW(InputTable[Sector] = UNIQUE(TOROW(rowLabels2, 3)), ORλ),
data, FILTER(InputTable, region? * sector?),
totals, HSTACK({"Totals", "", ""}, SUM(TAKE(data, , -1))),
VSTACK(InputTable[#Headers], data, totals)
)
Do you mind if I update the article I shared the other day, adding a link to this discussion and mentionning your 365 alternative?
(interesting to note that since I posted the article it got 20 more views, still nobody found it helpful)
Of course you may, use what you want and by all means put your own spin on it!
I did set up a help forum on LinkedIn for Lambda questions but it is still pretty much dead. I do wonder to what extent the Excel user base is even aware of the extent to which the art of spreadsheet development has changed. Power Query is still grossly underused and for Lambda it appears to be even worse.
Thanks PeterBartholomew1
...by all means put your own spin on it! I won't, am too lazy 🙂
Forgot to mention that I updated the article the other day. Hope that's fine with you otherwise let me know what should be changed & Thanks again
(obviously nothing was good enough to deserve any kind of feedback from tomasnavarro ...)
