hi @MichelleH, Thank you for the advice. in additional, if i keeping a separate date column and creating a pivot table card, for this pivot card is it possible to make as a input dataset for further processing?
hi @RobSomers, the closing parentheses is already included. the screenshot didn't include it only.
hi @mhouston and @RobSomers, thank you for the beast mode suggestion. I adjust my beast mode calculation and applied on the pivot table. the result is really fit my expected but i still got some issue on it. issue 1: dun know why there is an 50% difference shown in below. it is really tricky if i make a html table and…