Change Total with two criterias

[Anonymous]

Hi,

in this table there are 3 rows:

Non-Supplier-caused

Supplier-caused

Sum Structure

Total of these rows is Sum(cost_eur). If I will have only ‘Non-Supplier-caused’, formula will change to sum({}cost_eur). How is the right formula for the rows with 'Non-Supplier-caused' and 'Supplier-caused'

All values: Sum(cost_eur)

Non-Supplier-caused : sum({<structure_name={'Non-Supplier-caused'}>}cost_eur)

Supplier-caused : sum({<structure_name='Supplier-caused'}>}cost_eur)

Regards Stefan

[v_iyyappan]

Hi,

Try like this,

Non-Supplier-caused = Sum(${<structure_name={'Non-Supplier-caused'}>}cost_eur)

Supplier-caused = Sum({$<structure_name={'Supplier-caused'}>}cost_eur)

And presentation tab unmarked the show partial sum when use the pivot table.

Regards,

[Anonymous]

Hi,

can i do this in a listbox?

Stefan