I have two datasets. The first dataset gives me the Main categories of Media from one table. The second dataset gives me the Subcategories of the previous tables from another table.
ID | Category
1 | Category1
2 | Category2
3 | Internet
ID | Subcategory | MEDIA_FK
1 | Newspaper | 1
2 | TV | 2
3 | Radio| 2
4 | Google | 3
Then, in my mobile report, I show the Main Category on a circular graphic (Dataset1). And the subcategories on a Category bar graphic (Dataset2).
The problem is, that the Circular Graphics gives color to each category, but the Bar graphic color is only blue. I want the bar graphic to give the subcategories the same color that their respective main categories have on the circular graphic. Like this:
How can I do that? Can I do that?
I also tried with Total Graphic Bar. But the colors has no relation with the Circular graphics, and for two Subcategories with the same Main Category, it gives two different colors.
If the colors of the bar graphics (category or total) cannot have relation with the colors of the Circular graphic, can I at least to group the subcategories by colors (two subcategories with the same main category with the same color)?