Rounding decimal places in pivot table

Dear All,

I am trying to round to two decimal places in the pivot table.

The table visualization works perfectly, it is rounded to two decimal places. When the output is displayed in pivot table it is showing 6 decimal places.

I am using mongodb version 4.0 so i will not be able to utilize the round or trunc functions. Does redash provides the formatting similar to one in table visualization?

Another question is there a way we can hide the Totals at the end of each row? I have made don’t show row total still i is showing in the pivot table

Vijay K