Hello i have a table as below, i trying to get the % digital and % Non-Digital for each week commencing
Week Commencing | Digital | Non- Digital |
01/01/2000 | 100 | 50 |
07/01/2000 | 75 | 89 |
14/01/2000 | 50 | 50 |
Solved! Go to Solution.
Total Channels =
SUM('Example Table'[Digital]) + SUM('Example Table'[Non-Digital])
Digital % =
DIVIDE(
SUM('Example Table'[Digital]),
[Total Channels]
)
Non-Digital % =
DIVIDE(
SUM('Example Table'[Non-Digital]),
[Total Channels]
)
Total Channels =
SUM('Example Table'[Digital]) + SUM('Example Table'[Non-Digital])
Digital % =
DIVIDE(
SUM('Example Table'[Digital]),
[Total Channels]
)
Non-Digital % =
DIVIDE(
SUM('Example Table'[Non-Digital]),
[Total Channels]
)
Hey @NewbieJono ,
I'd like to help, so would you, so could you clarify your ask?
You'd like the % of Digital & % Non-Digital in comparison to the prior week?
No i just need to show the split each wek
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |