Forum Discussion

ek2112's avatar
ek2112
Advocate II
8 years ago

Dynamic calculation based on slicer selection

I have two tables, 'Work Details' and 'Rate' and linked by 'Name' column. Each employee has their own hourly rates in the 'Rate' table's 'Rate' column.   I have additional columns in the Rate table...
Need Help
ek2112's avatar
ek2112
Advocate II
8 years ago

RMDNA

 

Thanks for looking into this. Here is how I envision the expected result (I mocked this up in Excel):

 

 

 

 

 

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

Very helpful - if that's fabricated or anonymous data, it'd be useful if you could upload it to Dropbox/OneDrive/etc. and share the xlsx directly.