Sep 27 2021
Any chance that OLAP Support would ever be added to Mac Excel? I built huge dashboards to be used by execs in our company however I had to use the OLAP model to use the Distinct Count function.
To do this means they do not work on a Mac of course.
The other alternative is to use normal pivot tables but these do not have distinct count without using VERY sloppy work arounds.
Can we please either have DISTINCT COUNT built into normal pivot tables or have OLAP support on Mac?