Forum Discussion
Solved
Slicer Working On Only Half a Calculation
Hey friends, I've been working on this for days and cannot figure out a solution. Any suggestions would be welcome! Below is a mock up sample of my data. Basically I have a table with a number of...
I figured it out! Just in case this can help anyone... The slicer seems to only work on a single table. So even though both my tables had Company and Product fields, the slicer wasn't recognizing the fields from Table 2. I added my Active Months column to my Table1, created a calculated column AVG = Admits/Active Months and it works! :)
I figured it out! Just in case this can help anyone... The slicer seems to only work on a single table. So even though both my tables had Company and Product fields, the slicer wasn't recognizing the fields from Table 2. I added my Active Months column to my Table1, created a calculated column AVG = Admits/Active Months and it works! :)