Microsofti just got them, too. i do see a couple issues. where can i send them to be investigated?
using pivotby and choosing min or max, the total row shows the MIn or max value instead of the total. percentof works correctly.
the sort doesn't seem to work on all columns, just the first and totals columns in my scenarios., not the 2nd or 3rd column.
i'm using tables, not cell address in my testing and for the most part they work fine. i just see an anomaly in the header row in certain cases. (see below)
these are formulas i've tested in case anyone is curious:
and i do have some sort columns in {} because i'm testing multiple sort columns.
=PIVOTBY(CHOOSECOLS(Table1, 2, 6, 7),YEAR(Table1[DATE]),Table1[WEIGHT],SUM,0,1,{1})
=PIVOTBY(CHOOSECOLS((Table1[#All]), 2,6,7),YEAR(Table1[[#All],[DATE]]),(Table1[[#All],[WEIGHT]]),SUM,3,1,{1})
=PIVOTBY(HSTACK(Table1[CUSTOMER], Table1[ITEM], Table1[DESCRIPTION]), YEAR(Table1[DATE]), Table1[WEIGHT], SUM, 0)
=PIVOTBY(HSTACK(Table1[[#All],[CUSTOMER]], Table1[[#All],[ITEM]], Table1[[#All],[DESCRIPTION]]), YEAR(Table1[[#All],[DATE]]), Table1[[#All],[WEIGHT]], SUM,3,1)
the #value in the header is generated witteh above formula.
=GROUPBY(CHOOSECOLS(Table1, 2, 6, 7),Table1[WEIGHT],SUM,0,1,{1})
=GROUPBY(CHOOSECOLS(Table1[#All],2,6,7),Table1[[#All],[CASES]:[WEIGHT]],SUM,3,1,4)
and if the headers don't work correctly, i can use this above it the formula
=CHOOSECOLS(Table1[#Headers],2,6,7)
