Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator
Creator

aggr not working

Hi,

I have the below sample data.

Krish2459_58_0-1701080291348.png

I need the output like Accural type aggregation which should show 3 rows like above and the table should have only Savings_year as dimension.But Iam got sing row like below.

 

Krish2459_58_1-1701080496589.png

 

Thanks..

 

Labels (2)
2 Replies
TcnCunha_M
Creator III
Creator III

Hello
I don't think is this is possible , sorry but let me questioned you
Why you need Only the Year with the 3 values, but no information where that values come from, i don't think is readable in an easy mode, because we don't have any idea where that value came from, i believe this way might be little bit better no?
because you can may know where the value came from, or you make Pivot table 

TcnCunha_M_0-1701091580595.png

TcnCunha_M_1-1701091660617.png

 

As you think, so shall you become.
vincent_ardiet_
Specialist
Specialist

 If you want to see your result per Saving_Year, this field should also be present in the Aggr statement, else QS cannot allocate the data to it.