question

Gablic-8981 avatar image
0 Votes"
Gablic-8981 asked Gablic-8981 answered

ExcelScript.PivotLabelFilter condition

Based on doc: https://docs.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://docs.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.

office-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Gablic-8981 avatar image
0 Votes"
Gablic-8981 answered

Another question:
I'm trying to set a pivot filter with condition: >=3, is PivotLabelFilter the correct method?
200622-image.png



image.png (17.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Gablic-8981 avatar image
0 Votes"
Gablic-8981 answered

@IoTGirl Could you please check my question? Thanks a lot!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.