TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

[#1]

Hello,

i've a table with 2 dimensions (one of these is a value list whit three kpi), and I have to put a total which sum the KPIs.

It's possible have a total when there is a value list?

in this moment i've this:

and i want to put, in the same table, a total like this:

Someone knows if it's possible?

Thank you very much!

[Gysbert_Wassenaar]

Create a new field in the script for use as dimension in your pivot table. Add each

NewTable:

LOAD DISTINCT

     dual(Commodity,RecNo()) as ReportCommodity,

     Commodity as Commodity

RESIDENT

     ...source_table_that_contains_the_commodity_field...

ORDER BY

     Commodity

     ;

CONCATENATE (NewTable)

LOAD

     dual('Total', FieldValueCount('Commodity')+1) as ReportCommodity,

     FieldValue('Commodity',RecNo()) as Commodity

AUTOGENERATE FieldValueCount('Commodity')

     ;

Use ReportCommodity as dimension instead of Commodity in your pivot table. If you sort ReportCommodity numerically ascending the new Total value will be last.

[sunny_talwar · Accepted solution]

This?

Added a Inline table:

LOAD * Inline [

Dim

1

2

];

and change your first dimension to this:

=Pick(Dim, COMMODITY_SHORT_DESC, 'TOTAL')

and sort by expression -> COMMODITY_SHORT_DESC

[#4]

It's exactly what i need!

Thank you very much!!

[#5]

Thank you very much.

Silvia

[oknotsen]

If your question is now answered, please flag the Correct Answer (by clicking on Correct Answer).

If not, please make clear what part of this topic you still need help with .