% of Total Distribution with subgroups

Question

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.

Luke_C · Answer

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.

sphelps · Answer

@CathyS_Slalom I did that in the picture listed above but I need the sums to vary per date for both publishers.

CathyS_Slalom · Answer

Hi @sphelps, you can use the summarize tool to group by on Date and Publishers, and then sum columns A-C.