Field 2: Parent ID
Field 3: Subsidiary ID
What I need:
I want to create a stacked bar chart of # of parent records with subsidiaries vs. # of parent records without subsidiaries by region.
What I have now but how do I get to what I need:
Region is the X-axis. Parent ID is my stacked bars.
However, now I want to breakout the # of Parent ID records by bucketing the # of records with subsidiary records and # of Parent ID without subsidiary. I'm aware of the "create bucket" feature. I want to say if a Parent ID record has a subsidiary ID, then put it in bucket A. If the Parent ID record does NOT have a subsidiary ID, then put in bucket B. So, my graph will be a stacked bar chart of bucket A & B by region. How do I do that?
Thank you.
