crionsynx Posted June 24, 2020 Report Share Posted June 24, 2020 Is there a way on how to implement the distinct count for values in pivot datapage just like in Excel? I can't find it as option. Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted July 6, 2020 Report Share Posted July 6, 2020 Hello @crionsynx, I am afraid, that it is possible to count distinct values on the Pivot Report only in Totals & Aggregations. You may use Custom formula with the SELECT statement. However, it`s possible to filter results only by the fields that are used as Rows on the Pivot Report. For example: Hope this helps. Quote Link to comment Share on other sites More sharing options...
0 Kurumi Posted November 30, 2021 Report Share Posted November 30, 2021 Hi everyone! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery). It is available in R30 version: https://howto.caspio.com/release-notes/caspio-30-0/ Quote Link to comment Share on other sites More sharing options...
Question
crionsynx
Is there a way on how to implement the distinct count for values in pivot datapage just like in Excel?
I can't find it as option.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.