Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have apivot table ...If you look at the last field ( Expression) TotalTime it should display only one row for all the Severity jut like Number is bieng displayed ...
How can i achieve this ?
Can someone Please Advice on this
Please find the attachment of the qvw
To get that the expression should be made as dimension.
Add below expression in dimension.
=Aggr(Sum(TotalProjectAllocationhours),ProjectName,ReleaseNumber)
And replace existing expression with Sum(distinct 1)
Regards,
Kaushik Solanki
Hi kaushik this is not working ....
Change Sum(Distinct 1) to Count(Distinct 1)
See the attached example.
Regards,
Kaushik Solanki