user30972 Member

Comments

  • Having just had a similar problem, it seems like the partition statement works better when used with a field on the data set, rather than a calculation. Try using a data flow to create a column called SoldMonth that is equal to MONTH(`SoldDate`), and use that in the partition statement instead.
    in Percent of total by month in Pivot table Comment by user30972 June 2021
Default Avatar