Thanks @David_P1 , I had tried it but it didn’t work well with a distinct and a pivot giving incorrect results.What I did find out was that the default behaviour when used in a pivot is to count a total per row, so this little parameter solved it!dir...

Hi,Any way to do this in LookML?The reason is we’re trying to set queries that are shown in the quick start where table calculations cannot be preset.Thanks!