Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a pivot table for each weekend and there is a expression actual hours and budget hours . i have requirement to hide only Total Actual hours ( only bolded one , actual hours for week end date should be present and also there should be Total budget hours ) ?
say have i have 5 expression for each weekend date and have subtotal for all 5 expression in pivot table and i want to hide 2 expression only for total ..
is that possible?
Weekend date | 03-01-2015 | 03-01-2015 | 03-08-2015 | 03-08-2015 | Total | Total | |
Fullname | Dept | Actual Hours | Budget Hours | Actual Hours | Budget Hours | Actual Hours | Budget Hours |
Riya | Analytics | 10 | 12 | 1 | 3 | 11 | 15 |
Rekha | Development | 11 | 2 | 2 | 4 | 13 | 6 |
Thanks
You could query and react with dimensionality() and secondarydimensionality() the dimensions-level - like:
if(dimensionality() = 0, 'not calculated', sum([Actual Hours])
- Marcus
Hi revathikesari,
Can you attach the application with the sample data. This will help the folks to give the answer quickly. Thanks.
Hi,
If you want to hide/show the expression you can use conditional expression. so based on the given condition the expression in pivot table will be visible/invisible.
Eg: =SubStringCount(Concat(%Met_No,'|',%Met_No),'01')=1
Hi,
Use conditional Enabeling of Expression.
Thanks
Hi,
Try this.
uncheck the Show Partial Sum for Weekend date field only