Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Duplicated Sums display in Adobe

Avatar

Avatar
Validate 1
Level 1
jakubl3000
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
jakubl3000
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
jakubl3000
Level 1

13-03-2019

Hi all,

I would like to ask if there is any way to display sums that are duplicated (as compared to the usual de-duplicated sums displayed everywhere), without downloading the data to Excel and summing in there manually?

What I found was

- if I do a calculated metric and select it to be "TOTAL" (instead of Standard) it gives me just de-duplicated sums, so not what I want

- if I do a calculated metric and insert a "COLUMN SUM" function, it actually gives me precisely what I want, BUT it does not work with monthly granularity, i.e. it always gives the column sum of the entire selected period in a report, I would need it to split it by monthly granularity so that it displays just the COLUMN SUM of each month

Any ideas?

Thanks,

Jakub

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

29-03-2019

Yeah, the only other thing I can think of would be to adjust the date range and granularity so the column sum gives you the duplicated data you're looking for. This might take multiple freeform tables, though.

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
jakubl3000
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
jakubl3000
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
jakubl3000
Level 1

21-03-2019

Hi,

Thank you for the reply. Unfortunately it does not change results, results are still a sum of the entire date range and not split per dimension. I suppose it is intended that way, was just wondering if there is no way how to actually split them.

Regards,

Jakub

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

20-03-2019

With the month dimension, are you using the purple date one or orange dimension one? Do results change if you switch to the other?