Breakdown of Total instead of just the total

[#1]

Hi Guys,

I hope you can help me on this.

I have a Pivot chart that displays 3 Dimensions:

Country Manager, Country, Item Type...

I have set it up to display the subtotal for each dimension. And therefore the there will sub total for Country Manager.

Aside from displaying the total for Country Manager I also wanted to display the breakdown of the total pero Item Type.

Please see attached QVW.

Thanks in advance.

Regards,

~skip

[jagan]

Hi,

I think it is not possible to display the breakdown of the total by Item type. Instead you create another widget and display beneath the pivot table.  Please check the attached file.

Hope it helps you.

Regards,

Jagan.

[whiteline]

Hi,

In some cases you can use the following trick.

Add another table with Country as a key and "Total" field like this:

TotalTrick:

LOAD Distinct

      Country,

      Country as TotalCountry

Resident Data; //Data is your table "Country, Item Type, Quantity"

Concatenate(TotalTrick)

LOAD Distinct

      Country,

      'TOTAL' as TotalCountry

Resident TotalTrick;

Then use TotalCountry field as table dimension instead of Country field.

upd:

[#4]

Hi Whiteline,

Thanks for the info, this actually my workaround for the meantime even in the grand total. However it still doesn't seem right since TOTALS will not be presented in BOLD which should be the case, and puting TOTALS using the SUB TOTAL will generate x times of value based on how many times you the the CONCAT.

Thanks for the response.

~skip

[whiteline · Accepted solution]

Oh, Its quite simple

Expand the dimension TotalCountry.

For backgroud color use =if(TotalCountry='TOTAL', syscolor(4))

For text format use =if(TotalCountry='TOTAL', '<B>')

Now I think you can change 'TOTAL' into 'Total'.

[#6]

Hi Whiteline,

Thanks for this, I actually never used the formatting at this level.

Thank you very much, my report looks real Sub Totals Now.

Regards,

~skip

[montubhardwaj]

Indeed, a very good and handy trick. Thanks.