How to Do Fuzzy Matching with a Snowflake UDF
|
|
0
|
92
|
November 25, 2023
|
Dynamic Table Sizing
|
|
1
|
19
|
December 5, 2023
|
Use Variable Databases
|
|
4
|
24
|
December 4, 2023
|
How to Use Groupings & Aggregate Calculations
|
|
3
|
942
|
December 6, 2022
|
How to hide underlying data table in the application embed?
|
|
1
|
332
|
November 13, 2023
|
Empty Headers for Custom Export
|
|
1
|
35
|
November 2, 2023
|
How to Build Advanced Pivot Tables with Unions -and- Workaround for Custom Pivot Subtotals
|
|
3
|
869
|
November 27, 2023
|
How to fill in missing dates in table elements
|
|
4
|
131
|
November 17, 2023
|
Use a Switch to quickly show and hide rows with Nulls
|
|
0
|
73
|
August 10, 2023
|
Is there a limit of Number of Rows/Columns in Pivot Table
|
|
2
|
50
|
August 14, 2023
|
FAQ: How to add totals to a non-pivot table
|
|
1
|
172
|
August 11, 2023
|
How to improve workbook performance
|
|
1
|
1012
|
August 7, 2023
|
FAQ: How to do "like" string comparison?
|
|
1
|
57
|
July 27, 2023
|
How to use the "Add Column via Lookup" wizard to bring insights from a grouped table into a flat table
|
|
2
|
567
|
November 17, 2023
|
FAQ: How to view the underlying data of a chart
|
|
2
|
58
|
July 27, 2023
|
How to structure a table to use lead/lag functions per use case requirements
|
|
1
|
262
|
July 19, 2023
|
FAQ: How do I switch from rows to columns in my pivot table?
|
|
2
|
61
|
July 17, 2023
|
How to add/remove totals from a pivot table?
|
|
3
|
73
|
November 11, 2023
|
How do I union two tables?
|
|
2
|
84
|
October 29, 2023
|
How to Convert Business Hours & Calculate Difference in Business Hours between Two Events
|
|
3
|
510
|
July 19, 2023
|
Add multiple tables into separate pages in a worksheet
|
|
2
|
156
|
October 29, 2023
|
Finding Downstream Reports From Datasets/Tables
|
|
2
|
371
|
November 11, 2023
|
Aggregate Calculations in Pivot Table using Rollup
|
|
3
|
310
|
October 17, 2023
|
Pivot table percentage calculations
|
|
24
|
1433
|
October 22, 2023
|
Total of calculation in pivot table
|
|
5
|
617
|
October 27, 2023
|
Calculations in Table
|
|
4
|
437
|
October 29, 2023
|
Display multiple line of text (or wrap text) in pivots or tables
|
|
2
|
773
|
October 29, 2023
|
Customizing Color Scale for Pivot Table Values
|
|
2
|
311
|
October 29, 2023
|
Change the Formatting of Rows in Pivot Tables
|
|
2
|
338
|
October 29, 2023
|
Replacing a Join With the Same Table From a Different Database
|
|
2
|
353
|
October 27, 2023
|