I am trying to calculate Grand Total at the end of the table. It is adding one row where Grand Total text is displayed but all other fields are showing Blank. What could be the possible reasons ?
The data is probably null in this case.
One possibility is that you have a table calculation filter, filtering out the totals. Here sum(sales) you're seeing on filter shelf is actually a quick table calculation.
In which case "Apply to Totals" setting can come in handy to control when to show those values or not.
You might be using discreet measures
Retrieving data ...