create two separate sheets .. one is for CP from this sheet remove sum(PP) similarly create sheet for PP from this remove sum(CP)
then include these two sheets in dashboard...is this make sense ?
1 of 1 people found this helpful
On the marks card (above measure values), remove the SUM(CP) and SUM(PP) fields from that shelf. Then click the Label button and select 'Show Marks Labels'
Thanks Tom .
I made up a mock version with Superstore, and this is what I came up with:
I know it doesn't include the heart shapes, but I think it represents what you're trying to do with the data. The Marks card and Measure Values card are where the main differences lie. Let me know if this helps get you in the right direction!
I believe a Dual axis chart will also solve your problem