How to selectively show grand total for columns or rows on pivot table

hi

i using excel 2013 self bi feature following reports

here pivot table settings

as can see, grand total dates not making sense. how can disable grand total dates while keeping totals other value fields?

thanks

regards

---

jl

another approach use iscrossfiltered-function, if no slicers or filter fields used on pivot table:

if(iscrossfiltered(facttable[anycolumn]);[firstvisit];blank()))

whereas replace parameter of iscrossfiltered real column of fact table.

 

---

SQL Server  >  Power Pivot