Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
there is no workaround i can think of
so you can limit the total to display only in one cell