Percentage of first 15 elements

[Anonymous]

Hi,

I built a straight table , where I've shown the first 3 items on a total of 10 items.

Client	Actual	Previous	% Act - Pvs
A	10	5	100%
B	15	10	50%
C	20	15	33%
Total	45	30	75%

When I do the subtotal, the columns Actual and Previous give the right result, but the total percentage (the red value) is wrong!! (the total could be 50%).

Instead of doing the sum of partial values (3 items), it sums the total values (10 items).

I've also set the formula on : expression -> mode of totalization (total expression)

Could anyone help me please?

Thanks!

[shiveshsingh]

Please share the app

[Digvijay_Singh]

Not sure how are you filtering your total 10-15 items to 3 items? Are you making selections in filter to reduce your straight table to 3 items?

[isingh30]

Your straight table is not correct. Can you share the data?

[Anonymous]

Hi,

Share the sample App

Thanks & regards,

Venkata Sreekanth

[Anonymous]

3 Items were just an example. I filtered on 15 items.

The question is.....why the total percentage is on the total and not on the subtotal?