Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
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
It's exactly what i need!
Thank you very much!!
Thank you very much.
Silvia
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 .