How to perform aggregation

[vikasshana]

Hi,

I've below data.

As Of Month	Period	Num	Den
2025001	2024005	0	0
2025001	2024006	0	0
2025001	2024010	0	0
2025001	2024011	0	0

I'm trying to create chart with As Of Month, sum(Num) and Sum(Den) and end up with the below chart

As Of Month	sum(Num)	sum(Den)
2025001	0	0

But expecting below output

As Of Month	sum(Num)	sum(Den)
2025001	0	0
2025001	0	0
2025001	0	0
2025001	0	0

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[rubenmarin · Accepted solution]

Hi, so you want to see the same values in the dimension? Maybe using Dual([As Of Month],Period) as calculated dimension.

It could be  Dual([As Of Month],Num#(Period,0)) if Period is a string.

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[vikasshana]

thank you, it is working..!!!