Pivot Table More Months
I have a pivot table that I have seen before where horizontally you can see the months. But on this particular one it only goes until July
Answers
-
How far does your data go? If you want to see the future months you need to have those months in your dataset.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Currently it should go until September but it only shows until July without a horizontal scroll
0 -
Hi @Josh_Evans20,
Please review for any applied filters or sorting. Identify if there are columns displaying ### in red. Are you using any Beast Mode? If you provide a screenshot with a little more information it would be helpful.
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0 -
Here is the screenshot, for example there is data for August September but the pivot table doesn't allow a horizontal scroll. Another question is the three hashtags, they are 0 but show those numbers instead.
0 -
Hi @Josh_Evans20,
I'm not certain, but there may be an issue with division by zero, or the values in the dataset could be Null rather than 0.
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0 -
I set the values to zero and there isn't any formulas for this value.
Also, do you know if the pivot table can handle more than 7 columns at a time?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive