community.sigmacomputing.com Open in urlscan Pro
2602:fd3f:3:ff02::4b  Public Scan

Form analysis
1 forms found in the DOM

POST /login

<form id="hidden-login-form" method="post" action="/login" style="display: none;">
  <input name="username" type="text" id="signin_username">
  <input name="password" type="password" id="signin_password">
  <input name="redirect" type="hidden">
  <input type="submit" id="signin-button" value="Log In">
</form>

Text Content

Sigma Community


HOW TO BUILD ADVANCED PIVOT TABLES WITH UNIONS -AND- WORKAROUND FOR CUSTOM PIVOT
SUBTOTALS

Knowledge Hub
Unions, workaround, Pivot, highlight, Table
Chandler November 1, 2023, 5:08am 1

image1000×550 25.3 KB



Many executive dashboards include large, complex pivot tables which show a
variety of metrics split across multiple periods and categories.

By default, Sigma’s Pivot Tables show every metric split by the same periods and
categories.

However, some executive dashboards require that some metrics be split into
different periods and categories from the rest.

In this video how-to, I’ll be going over how to accomplish this in Sigma by
unioning multiple Pivot Tables together into a single, more complex Pivot Table
…

… as well as how to use the same method as a workaround to create custom
subtotals on Pivot Tables!



I hope this video helps you fully leverage Sigma’s powerful Pivot Tables!

If you have any thoughts, questions, or suggestions for future topics, please
feel free to comment below!

Thanks for watching, and please join us for more video how-tos!

-Chandler Phelps, Sigma Support

3 Likes

Cathy Tags updated November 1, 2023, 5:13am 2

Added Pivot, Subtotal, Table, Unions, workaround



Cathy Tags updated November 13, 2023, 6:06pm 3

Added highlight and removed Subtotal



 * Home
 * Categories
 * FAQ/Guidelines
 * Terms of Service
 * Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled

Skip to main content

Sign UpLog In
 * 


   
   
 * About
 * Topics
 * Badges
 * Leaderboard
 * Upcoming Events
 * Knowledge Hub
   
   
 * More
   

Categories
 * Welcome Center
 * Forums
 * Events
 * Knowledge Hub
 * Ideas
 * All categories

Tags
 * FRQ
 * Formulas
 * Visualizations
 * Export
 * Dates
 * All tags



HOW TO BUILD ADVANCED PIVOT TABLES WITH UNIONS -AND- WORKAROUND FOR CUSTOM PIVOT
SUBTOTALS

Knowledge Hub
PivotTableUnionshighlightworkaround

You have selected 0 posts.

select all

cancel selecting

Nov 1
1 / 3
Oct 31

1d ago

ChandlerSigma Staff
2
14d


image1000×550 25.3 KB



Many executive dashboards include large, complex pivot tables which show a
variety of metrics split across multiple periods and categories.

By default, Sigma’s Pivot Tables show every metric split by the same periods and
categories.

However, some executive dashboards require that some metrics be split into
different periods and categories from the rest.

In this video how-to, I’ll be going over how to accomplish this in Sigma by
unioning multiple Pivot Tables together into a single, more complex Pivot Table
…

… as well as how to use the same method as a workaround to create custom
subtotals on Pivot Tables!



How to Build Advanced Pivot Tables



I hope this video helps you fully leverage Sigma’s powerful Pivot Tables!

If you have any thoughts, questions, or suggestions for future topics, please
feel free to comment below!

Thanks for watching, and please join us for more video how-tos!

-Chandler Phelps, Sigma Support


3




 * CREATED
   
   14d

 * LAST REPLY
   
   1d
 * 2
   
   REPLIES

 * 348
   
   VIEWS

 * 1
   
   USER

 * 3
   
   LIKES

 * 



Tags updated on Nov 1



Added Pivot, Subtotal, Table, Unions, workaround

12 days later

Tags updated 1 day ago



Added highlight and removed Subtotal




Reply




NEW & UNREAD TOPICS

Topic Replies Views Activity Different ways of sorting bar charts
Knowledge Hub
ChartVisualizations
2 457 Jul 25 To Pivot or Unpivot (how to transpose data via SQL)
Knowledge Hub
Custom-SQLPivot
1 687 Jul 19 Quick Chat about Outlier Detection in Sigma
Knowledge Hub
Analytics
1 873 Jul 25 How to use Hidden Filters in Workbooks to customize your workbook
Viewer’s experience
Knowledge Hub
FiltersControls
1 428 Jul 25 Calculate Monthly Active Users from a Table with Start and End
values, aka “The Classic HR Headcount Problem”
Knowledge Hub
AnalyticsFormulas
1 199 Jul 26


WANT TO READ MORE? BROWSE OTHER TOPICS IN KNOWLEDGE HUB OR VIEW LATEST TOPICS.









Invalid date Invalid date