cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajal161292
Helper V
Helper V

To calculate the cumulative total across a row.

I have arequirement of computing the cumlative total across a row per different weeks.

Please help me in carrying out the same.

 

capture3.PNG

 

For week 45 it should be 1666.72

For week 46 it should be 1666.72+(-1924.60)+0+0 = -257.88

For week 47 it should be -83.32 +(-257.88) = -341.2

etc.

So at the end it should display the total adding up all of the weeks.

2 ACCEPTED SOLUTIONS

@sajal161292

 

Are you sure you doing it correctly see my screenshot I have the same layout as your table:

Capture33.PNGCapture34.PNG

View solution in original post

@sajal161292,

 

Since your problem has been resolved, please help accept solution. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Abduvali
Skilled Sharer
Skilled Sharer

Hi @sajal161292,

 

 

Try using Matrix table and switch all total ON or they probably switched on by default:

Capture32.PNG

 

 

Regards

Abduvali

Hi @Abduvali

 

Thank you for your reply

But i need to add across all the rows.

By switching it ON its adding up only for the columns under it.

 

Capture4.PNG

While i need to add week 45,46,47 etc.

i.e 1666.72 + (-1924.60 +0 +0 +0)+(-83.32)+ (-130.40) + (-110.82) at the final output.

@sajal161292

 

Are you sure you doing it correctly see my screenshot I have the same layout as your table:

Capture33.PNGCapture34.PNG

View solution in original post

Hi @Abduvali,

 

It worked for me.I didn't turn the column subtotal.

Thanks fpr your help!!

 

@sajal161292,

 

Since your problem has been resolved, please help accept solution. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors