Is it possible to by pass a dimension in Pivot table

[tresesco]

Hi All,

Here i have an issue of by passing a dimension in in expression (in PIVOT TABLE). For reference please find the attachment.

any input would be appreciated. Thanks...

[#2]

Hi,

You could try : aggr( sum(Value), Country )

[llauses243]

Hi,

basic rules ... aggr sum aggr NO, sum aggr sum NO

my offer is simil to Xena but as ... aggr( distinct sum(Value), Country )

good luck ,Luis

[#4]

Or this also works : sum(total <Country> Value)

[tresesco]

Thanks for your reply. But it does not help.... i don't want blank....look at the attachment.

Regards,

tresesco.

[#6 · Accepted solution]

The last expression works, with no blanks.

[tresesco]

Thanks Xena. It worked!!

[pablolabbe]

llauses wrote:
basic rules ... aggr sum aggr NO, sum aggr sum NO<div></div>

Hi Ilauses, what do you mean with this basic rule ?