• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

slicer question

Joeman187

Member
Hi Chandoo Experts,

I am having trouble understanding the slicer connections. In the batting dashboard I have "Choose A Player" slicer that works nicely with my vlookup and the pt to the far left. I wanted to add the Players bio to the dashboard. When I look at the reports connection (The choose a player) it does not have that pt check box. Can use that slicer to connect to the players bio and work all three from one? Also, in the players bio i have wieght and dob of each player. I only want to have it on the same line as the players name. Can I do that also? I want to do the same for the pitching dashboard so can you give a detail step by step on what to do so i can figure it out by my self. Thanks so much for your help on this problem. Joe from Michigan.
 

Attachments

  • Detroit Dashboard LM (1).xlsx
    744.1 KB · Views: 8
Hello again Joe,

As you've discovered, the new Bio PT has a different data source, so we can't immediately connect it's slicer to the other tables.
For the layout, we could get the desired layout at least by removing Grand Total, Subtotals, and changing Report Layout (Design - Report Layout - Tabular)

However, I think overall solution is to ditch the PivotTable, and just use formulas. Since you're only returning info about the 1 selected player, this won't require many formulas. :)
 

Attachments

  • Detroit Dashboard LM2.xlsx
    752.3 KB · Views: 4
Hey Luke,

Thanks again for your assistance. That's what I wanted. Pretty funny how you replied to me again. Many thanks. Joe.
 
Back
Top