Complexity

[smilingjohn]

hi All,

I have a pivot table .....In which the expression are duplicating if u see in the image which has7000, 261...and so on repeating for

sevrity1, 2 3 and 4 ..... actuall it shoul display as only 7000 , 2611.... for all the severity just like Number 17.6 has all the severity ...similarly i want to show  for the expression too...

To achive this iam using below expression but still its not working as i need

PLease let me know if the expression is coorect or what needs to be done ?

sum({<ALMMasterGroup,ProjectName,ReleaseNumber,RSeverity>}TotalProjectAllocationhours)

even i tried the calculated dimension its not working ...

aggr(sum(<RSeverity,ReleaseNumber>,TotalProjectAllocationhours)TotalProjectAllocationhours)

I have attached the sample of qvw file....How do we achieve this ....

Thanks in Advance

[lironbaram]

hi

if you want the display to be like your dimension ,

you'll need to create a calculated dimension

expressions are calculated at row level.

[smilingjohn]

HI Aron

Thanks for the reply I have attached the qvw file ....If I make it at dimension level then I will not be able to move the column towards right side in pivot table ....

Please do suggest

[lironbaram]

there is no workaround i can think of

so you can limit the total to display only in one cell