Dimensionality

[vijetas42]

Hi all,

Can any one suggest any solution for below scenario,

I have used Dimensionality() in pivot table to hide my repetative(same) values for multiple row and displayed it only in total row and added partial sum on column which is at 1st position in table,but when i move column to some other position all total values goes blank

Thanks,

Vijeta

[Anonymous]

go and change/check your expression where you have written dimensionality() function.

--Anant

[qliksus]

Can you attach some sample files ? or Post What is your expression ?

[vijetas42]

I have expression like this,if(dimensionality()=1 and currency='gbp',sum(sales),if(dimensionality()=1 and currency='eur',sum(sales)/exch_rate))

and i have written dimensionality in expression because,

I am having data like this,

Proj_def Vendor_name sales

P1             v1                2500000

                 v2                2500000

so, in this data i want to show ,

Proj_def Vendor_name sales

P1             v1               

                 v2               

                 Total          2500000

[Anonymous]

how could using partial sum hide repetitive values actuall it sum of multiple rows and display a partial sum

for each categaory , can you go back  and revert back to same and check all partial sums,

also if you have multiples column then that means you need to use

pick( dimensionalty()+ 1,yourExpr , AGGR ( YourExpr,column1 ),AGGR(YourExpr,Column1,Column2 )

so if only if none column is expanded in Pivot table then partial sum will be on first column

as soon as you click + and if two column is visble that means you need aggr on two dimensions so

AGGR(YourExpr,Column1,Column2 )

--Anant