Hello,
How do I create a % of a column for two consecutive types of groupings? For example, I have dates and publishers, but I want to create the totals by week of what the total publishers are:
After the summary and the target/source tool, this is the result:
In this example, it is giving me a total number for all weeks/dates. I would like the totals to vary by date grouping the publishers.
Hi @sphelps, you can use the summarize tool to group by on Date and Publishers, and then sum columns A-C.
@CathyS_Slalom I did that in the picture listed above but I need the sums to vary per date for both publishers.
Hi @sphelps
It would be helpful if you shared some sample data (not screenshots), the workflow you have (simplified to the problem area), and an example of the final result you want.