Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Try if(rowno()=0,...)
BR
Serhan
i have tried it .. the qvw file getting terminated after that .
hi can u see the issue and tell me the correct expression plss
Did you use an aggregation or sum function in the Final Performance expression? Wihout them, in the pivot table subtotals won't be shown. Put it in your expression, and let us know what are the results!
Br,
T
what kind of expression can i write over there??
It depends on what you want to represent there. Just an example: sum(Performance)
The main idea is to use some kind of aggregation function, because that is a requirement for subtotals to appear in a pivot table.
BR
T
as i want to make aapear the grand total as dimensionality()=0 .
how can i write the expression over there according to the screen shot .