Creating subtotals in a table

[shamitshah]

Hi,

Please see attached.

How can I create subtotals by either Fruit Country or City?

Thanks

[MarioCenteno]

!Maybe something like that?

[shamitshah]

Is it possible in a straight table?

[MarioCenteno]

Sorry I don't understand, yo could me explain a little more

[Anonymous]

Yes it is. But can you explain more on what are you looking for? It is not very clear for me what you want.

[shamitshah]

Please see attached sample of the output.

[Anonymous]

Here is the sample i created:

Your table value is called Sum(Sales), so i will write it like this "[Sum(Sales)]"  for easy understanding.

SUM FOR APPLE:

Sum({<Fruit={'Apple'}>}[Sum(Sales)])

SUM FOR LA

Sum({<City={'LA'}>}[Sum(Sales)])

SUM FOR USA

Sum({<Country={'USA'}>}[Sum(Sales)])

BAR GRAPH:

DIMENSION -> Fruit

MEASURE    -> Sum(Sum(Sales))

PIVOT TABLE:

ROW:

Country

City

Fruit

Column:

void

Measure:

Sum([Sum(Sales)])

Straight table:

In a straight table it is not good practice to use a lot of dimensions, so use the one you think is better.

The straight table is like this:

Columns:

Country

Sum([Sum(Sales)])

I hope that helps.

Like, Mark as the answer and mark as helpful if it is. It helps a lot.

Thanks!