Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In the attached sample app, I'd like to be able to ignore the year slicer in the displayed pivot table.
Any ideas?
Thanks
Shashank
Hello @Supertramp0 ,
Try something like this in your expression
PICK(minstring({1}D8ID),SUM({< Year = >}Score)
)
Regards
Eddie
Hello @Supertramp0 ,
I see the tables are not connected with each other. I don't understand why... Because if you do so, then it should be no problem at all
[D8]:
LOAD * INLINE [
D8ID, D8Name
1, Avg.TAT - Payout Ordered - Payout Resolved
2, % of Payouts - TAT < 5 BD
3, % of Payouts - TAT < 8 BD
]
;
[D] :
LOAD * INLINE [
Year, Score, D8ID
2015, 600, 1
2016, 700, 1
2017, 800, 1
]
Then you can use in the expression:
sum({1}Score) or sum({$<Year=>}Score)
Regards Eddie
Hello Eddie,
I can't connect them because Table D8 is simply being used as a table of values to describe certain calculations made in Table D ( the table with the actual data).
Is there a way to make it work without joining the tables - as there is no real join.
Thanks
Shashank
Hello @Supertramp0 ,
Try something like this in your expression
PICK(minstring({1}D8ID),SUM({< Year = >}Score)
)
Regards
Eddie
Thanks Eddie. Worked well