Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=sum(aggr
(count({< CalendarMonthNum=,CalendarYear=,Date=, BookingStatus={'Booking','Booked','Car Allocated'}>}distinct(Booking_ID)),
RM_Name,AM_Name,DealerCode,City_Name,Model,ModelCode))
The above measure is an expression Pivot Table.
I have 2 doubts :-
1) This expression is not able to bypass the fields.
2) I want to add 1 more dimension in my pivot . However, whenever I add the same in aggr function along with rest of the fields , my total value changes .
include the by passing in the sum:
sum({<CalendarMonthNum=,CalendarYear=,Date=>}aggr(count({<CalendarMonthNum=,CalendarYear=,Date=,....