4 Columns of data - but they don't all line up

Laura_M1

Hi!

We have 4 columns of data, but they don't all line up when in drill down mode; good news is that they do at a high level.

What are the steps needed to have these columns below all line up? Thank you!

GrantSmith

This is likely because you have the data as multiple rows instead of on a per-brand record. You can use a magic ETL with a Group By tile and then aggregate (with a sum aggregation) your revenue and quantities together so that each brand has one record with all your data together to condense the duplicated rows.