Subtotal Field A at change of Field B

[Anonymous]

Hi all,

In a straight table chart, I have one column displaying Sales Order No (s_order) and another column displaying the Sales order Total Inc (order_total).

I need to display a subtotal for "order_total" at every change of "s_order".

can anyone direct me on how to achieve this?

Thanks in Advance!!

F.Giorgio

[Anil_Babu_Samineni]

Look at partial sum from presentation tab?

[vinieme12]

Change your table to a pivot table and use Partial Sum option in the presentation tab for your field which you want see subtotals for

[sunny_talwar]

Above two suggestions are guiding you in the right direction, but for more help on this topic, share a small sample with the expected output.

[Anonymous]

Hi Sunny,

Thanks for your input...

here's a simplified representation of what the output should look like...

Price subtotal at change in Sales Order No...

Customer Acc	Sales Order No	Product	Price
Mr X	123456	Product A	10
Mr X	123456	Product B	20
Mr X	123456	Product C	30
		Price Subtotal	60
Mr Y	123457	Product X	5
Mr Y	123457	Product Y	10
Mr Y	123457	Product Z	15
		Price Subtotal	30

Is there a way this could be done in a straight table?

if not can a pivot table always display all fields as expanded?

thanks again for your assistance...

F.Giorgio

[Anil_Babu_Samineni]

Is there a way this could be done in a straight table?

Simply answer is No

if not can a pivot table always display all fields as expanded?

Yes, It would. Is that is okay for you. Same Thing straight table here you need to enable option from presentation tab called "Always Fully Expanded"

[vinieme12]

Partial Sums in straight table | Custom Labels in Pivot SubTotals

[Anonymous]

Hi Anil,

Sorry for the delayed reply, I only have time to work on this here and there...

I have now setup the report as a Pivot table and it looks great...

I have tried using the "Show Partial Sums" and I can roughly understand how this works however I can't get a subtotal of my Price at each change of SOrder...

Do I need to use the Sum(Price) expression and where do I put this in order for this to display under the price column?

If someone could let me know when you have a chance that would be appreciated...

Thanks.

F.Giorgio

[Anil_Babu_Samineni]

Good, Here you need to understand is how Partial Sum works

This is basic example to understand Partial Sums

For Editing the name, You could go like image, For your way this should run for "Sales Order"

[Anonymous]

Hi Anil and all,

I appreciate everyone's help and I did look at all the advise and links provided, however I still cannot understand how to achive this.

Here's an exerpt from my actual report below.

What I am trying to achieve is a subtotal sum of BOrders Total Inc and In Picking Total Inc at the change of every S/Order.

The subtotal row is in the correct place, but I cannot understand how to display the subtotals in that row.

I am not sure if there are expressions involved to achieve this and where these expressions need to be applied.

Any help would be appreciated...

Thanks