Pick and Set Analysis - Ignore Slicer

[Supertramp0]

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

[eddie_wagt]

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

[Supertramp0]

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

[eddie_wagt · Accepted solution]

Hello @Supertramp0 ,

Try something like this in your expression

PICK(minstring({1}D8ID),SUM({< Year = >}Score)
)

 Regards

Eddie

[Supertramp0]

Thanks Eddie. Worked well