Hey Ramz,

I would actually re-structure your data to get what you need. I've flipped it really quickly, creating a flag for "Parent/Child", and then being able to match on letter.

Workbook attached (Note: Using version 9.3).

Thanks!

Katie

Hi Ramz!

Sure thing.

The data structure is a follows:

With this structure, you'll need to create 3 calculations for each Sum:

ASum=sum(if ([Ident A])="A" then ([Figure]) end)

BSum=sum(if ([Ident A])="B" then ([Figure]) end)

CSum=sum(if ([Ident A])="C" then ([Figure]) end)

Then, you can create the Parent sheet as follows (just filter IdentB where it ="Parent", as showin in the Filter shelf):

Do the same for the Child sheet, just filtering IdentB where it = "Child".

And then in the Dashboard menu, just select Action, and then make sure you only select "Selected Fields, and choose that IdentA to filter on.

Hi Ramz!

Make sure IdentA is what you are coloring by, so that it is a detail level in both sheets. Is this the case? If so, could you post a screenshot of one of the sheets or re-post your workbook? Thanks!

Hi Ramz!

Wow, this is really cool. I have never used pivot, and I am just now reading about it. What a cool function.

I'm not too sure about the refresh... are you adding a new data source every time or scheduling an extract refresh from a database? While I've never used this function before, I know other changes I have made to date (i.e. splitting it, making it text instead of integer), have remained after an extract refresh.

The other option you have (depending on the source of your data) is to make custom Custom SQL in Tableau to structure it the way you need.