Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
@IoTGirl Could you please check my question? Thanks a lot!
ExcelScript.PivotLabelFilter condition
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 40%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Gablic
21
Reputation points
Based on doc: https://learn.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.labelfiltercondition?view=office-scripts
When condition set to ex "equals", "greaterThan", then "comparator" is required. However, in ExcelScript.PivotLabelFilter doc: "https://learn.microsoft.com/zh-cn/javascript/api/office-scripts/excelscript/excelscript.pivotlabelfilter?view=office-scripts
There is no such property as "comparator". I tried this in excel script, no surprise return me an error "Type '{ condition: ExcelScript.LabelFilterCondition; comparator: number; }' is not assignable to type 'PivotLabelFilter'".
How do I use "greaterThan" condition properly? Thanks.
Microsoft 365 and Office | Development | Other
2 answers
Sort by: Most helpful
-
Gablic 21 Reputation points
2022-05-10T09:45:59.047+00:00 Another question:
I'm trying to set a pivot filter with condition: >=3, is PivotLabelFilter the correct method?
