SQL Pivot Table

SQL Pivot Table

Hi,

So I am new to SQL and have been actively learning it whilst we have some time on our hands to improve our reporting.

I need to take data and present it as per a pivoted table the standard pivot function presents the data like this;


What I am trying to achieve is more like this:


So I found the support on pivots and have simplified my model so I can get an understanding (its about 1/3 of the way down);



So I have taken this and adapted it to my needs in a very simple form so I don't get too lost in it, before I fully understand it, so I have created this:

SELECT
"pivot"."Targets/Invoice/Backlog Owner" as "Targets/Invoice/Backlog Owner",
"pivot"."February Target" as "February Target"
FROM (SELECT
"Targets/Invoice/Backlog"."Targets/Invoice/Backlog Owner" as "Targets/Invoice/Backlog Owner",
"Targets/Invoice/Backlog"."February Target"
FROM  "Targets/Invoice/Backlog")
AS  "pivot-source"
pivot
(sum("pivot-source"."Targets/Invoice/Backlog Owner") FOR "pivot-source"."February Target" in ( "Targets/Invoice/Backlog Owner", "February Target"  )
) AS pivottable

Right now the error seems to revolve around line 9, Pivot (I highlighted in red).... or is it the Pivots in the 2nd and 3rd lines causing me issues?
Unknown table or alias 'pivot' used in select query.

am I being dumb, pointers would be nice if you have the time.

Stay safe

Iain 


    Access your files securely from anywhere








                            Zoho Developer Community



                                Bootcamp
                                Community
                                Pricing
                                Webinars
                                What's New
                                Integrations
                                Contact Support
                                Contact Sales
                                  Zoho Survey Resources
                                    Features
                                    Survey Templates
                                    Integrations
                                    Community
                                    iOS Mobile Surveys
                                    Pricing
                                    Android Mobile Surveys
                                    Insurvey Blogs
                                    Insight Blogs
                                    Tips & Tricks





                                                Latest Feature Updates

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts




                                                      Zoho SalesIQ Resources

                                                            • Sticky Posts

                                                            • What's New in Zoho Analytics - November 2025

                                                              We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

                                                            • What's New in Zoho Analytics - October 2025

                                                              Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

                                                            • What’s New in Zoho Analytics – September 2025

                                                              Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

                                                            • Announcing Agentic AI - Ask Zia!

                                                              We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

                                                            • Invitation-Based User Access in Zoho Analytics

                                                              Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security


                                                            Manage your brands on social media
                                                            Access Zoho Social

                                                              Zoho Pagesense Resources


                                                                  Zoho TeamInbox Resources

                                                                    Zoho DataPrep Resources


                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner









                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • Zoho Forms - Print Button on Forms

                                                                                                                Hi Forms team, I'm replicating a form for a client which is currently based on JotForm. I noticed that at the end of the form there is a button to print the completed form. I thought this would be something worth sharing and a nice to have in Zoho Forms.

                                                                                                              • Putting Watermark on Zoho Sheet

                                                                                                                Can this be done?

                                                                                                              • Validation function not preventing candidates under 18 or over 30 from submitting the web form

                                                                                                                Hello everyone, I’m trying to create a validation rule for the Candidate Webform in Zoho Recruit. I added a custom field called “Date of Birth”, and I want to make sure that candidates cannot submit the form unless their age is between 18 and 30 years.

                                                                                                              • Report to know the history of certain Tickets on Desk

                                                                                                                Hi there guys, As the title implies we're wondering if there's any way to get some kind of Report that allows us to check the History of various Tickets at the same time since as of today if we want to know that we have to check them 1 by 1 which is not

                                                                                                              • Advanced Usage Billing: Prepaid with Drawdown

                                                                                                                Picture yourself at your favourite coffee shop, Bean & Brew. You come by every morning for your usual cappuccino, and occasionally you get an extra cold brew and a muffin or two in the afternoon. Interestingly, Bean & Brew has a new idea of offering a

                                                                                                              • Zoho Commerce in multiple languages

                                                                                                                When will you be able to offer Zoho Commerce in more languages? We sell in multiple markets and want to be able to offer a local version of our webshop. What does the roadmap look like?

                                                                                                              • Urgent Zoho Creator down!!!???

                                                                                                                Now my zoho creator faced this issue. Anyone has idea? Urgent!!!

                                                                                                              • The Social Wall: September 2025

                                                                                                                Hello everyone, As we step into the fall season, some major updates are on the horizon. Meanwhile, here are the exciting updates we rolled out this September. Approvals in iOS Managing approvals just got more seamless on mobile. With this update, the

                                                                                                              • Introducing Detailed View for Candidates in Vendor Portal

                                                                                                                We’ve added a new Details sub-tab inside the Vendor Portal to help vendors easily view complete candidate information after submission. With this update, vendors can now access all candidate details, from personal information to associated job openings,

                                                                                                              • Zoho One Down

                                                                                                                Zoho Team, Checking if when the services up - currently Zoho One is down

                                                                                                              • How can I track which zoho users are actively using Zoho CRM

                                                                                                                I have several licenses of Zoho CRM. We now need to add a new user. I could purchase a new license, but before I do, I would like to see if any of our existing users are not actively using the license assigned to them. How can I determine the activity

                                                                                                              • Access to Detail View From HTML Snippet

                                                                                                                Zoho Creator displays a detail view that slides out from the right onClick of a record in a report. Am I able to access that detail view from an html snippet, e.g. click a record in a list and display the detail view? The zc_LoadIn dialog is a bit clunky,

                                                                                                              • Billing Management: #10 Solving Common Mistakes in Billing

                                                                                                                Over the past few weeks, we have explored different facets of billing, from the simplicity of traditional one-time billing to the evolving landscape of subscriptions, retainers, and usage-based models. We've unpacked how billing isn't just about sending

                                                                                                              • 【開催間近 - 10/17】東京 ユーザー交流会 Vol.3 参加登録 受付中！(参加無料)

                                                                                                                ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 10/17(金)に、東京・新橋で「東京 ユーザー交流会 Vol.3」を開催します！ ZOHOLICSよりも小規模なイベントですので、「リアル開催はちょっと緊張する…」という方も、安心してご参加いただけます✨ 当日は、初公開の事例を2つご紹介予定です！ なお、セッション映像のアーカイブ配信は予定していないため、会場にお越しいただいた方だけが、登壇者へ直接質問したり、リアルな声を聞いたりできる貴重な機会となっています。 ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー

                                                                                                              • Loading CSS Stylesheets into HTML Snippet

                                                                                                                Combining html/css into a single snippet can grow quite large for a UI that has a lot of functionality/styling. To keep things tidy, are we able to pull files into an html snippet using a <link> tag? If so, what are some best practices?

                                                                                                              • Notes Attachments

                                                                                                                Two things it would be nice to have the attachment size the same as the attachments sections and it would be nice to be able to attach links like you can in the attachments section. Thank you

                                                                                                              • Canvas: empty images

                                                                                                                Hello. If I add an image field like contact photo in a Canvas design, and the field is empty, there is an ugly placeholder in its place. This doesn't happen in the standard view. In the standard view, if the contact photo is empty, nothing appears in

                                                                                                              • Google enhanced conversions not working

                                                                                                                Hi guys, I've connected Zoho CRM through Google Ads interface with the goal to setup the enhanced conversion tracking in Google Ads. I have to Zoho related conversion goals which you can see in the images below: For the conversion goal above I've setup

                                                                                                              • Sync Contacts with iPhone

                                                                                                                Is syncing the Zoho Personal Mail contacts with the iPhone (or other mobile devices) in the works?  I just dumped Yahoo & then found out that contacts sync is missing.  Importing is only a stop gap and a step backwards for me.

                                                                                                              • MS Teams Meeting to Zoho CRM

                                                                                                                Has anyone figured out a good way to push MS Teams meeting info on a trigger of "meeting end" to Zoho CRM? We're looking for a way to take attendees of a meeting and meeting duration and push it into Zoho CRM after the meeting has ended. If I can just

                                                                                                              • How do I move a section or element from one page to another in the NEW Zoho Sites UI

                                                                                                                I have a section on my home page with numerous elements within it and I'd like to move the entire section to a different page on my site so I don't have to recreate it from scratch.  Is there a way for me to do that easily? I could use a quick answer on this please.

                                                                                                              • Zoho Projects app update: Global Web Tabs support

                                                                                                                Hello everyone! In the latest version(v3.10.10) of the Zoho Projects app update, we have brought in support for Global Web Tabs. You can now access the web tabs across all the projects from the Home module of the app. Please update the app to the latest

                                                                                                              • Export as MP4 or GIF

                                                                                                                Hi, Just wondering if there's a way to export/convert a presentation to an MP4 video file or even a GIF. One use case would be to use the animation functionality to create social media graphics/charts/gifs/videos. Thanks for a great tool... Rgds Jon

                                                                                                              • Page Layout- Horizontal Rule

                                                                                                                When editing the layout of, for instance, the Potentials page, is there a way to insert a horizontal rule or white space in between fields?  I'd like to keep a group of fields in the same Section, but would like to create some seperation in order to further group together certain fields within the Section.  If this is not possible, does anybody have any other suggestions on how to create this same effect?   Thank you!

                                                                                                              • Zoho Books will discontinue support for older browser versions soon

                                                                                                                Hello users, Starting from May 15, 2024, Zoho Books will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than 100

                                                                                                              • Zoho Projects - Q3 Updates | 2025

                                                                                                                Hello Users, The final quarter of the year 2025 has begun, and we at Zoho Projects are all set with a plan. New targets to achieve and new milestones to reach, influenced by the lasting imprint of the past quarter. 2025's Q3 saw some new features and

                                                                                                              • Issue with Trident exe file

                                                                                                                Hello Team, Exe Setup file It's showing harmful for user pc please check and do needful. this message for developer team. Thanks Bhargav Purohit

                                                                                                              • Transaction Locking with the dynamic date

                                                                                                                Is it possible to dynamically update dates on transaction locking. We want to lock transaction x days from today

                                                                                                              • Unable to change sales_order status form "not_invoiced" to "invoiced"

                                                                                                                I am automating process of creating of invoice from sales_orders by consolidated sales_orders of each customer and creating a single invoice per customer every month. I am doing this in workflow schedule custom function where i create invoice by getting

                                                                                                              • Apply Vendor Credits Automatically

                                                                                                                We are bulk importing Vendor credits in Zoho Books!!! Is there a way to apply vendor credits automatically to the first UNPAID bill of the Vendor?

                                                                                                              • Apply Vendor Credit Automatically

                                                                                                                Hello!!! Is there a way where in we can apply vendor credits automatically on the FIRST OUTSTANDING BILL of the vendor?? We have lots of VENDOR CREDITS ISSUES mostly!!! Applying it manually is a pain for us. Would be great if we have a way to apply the

                                                                                                              • Need Easy Way to Update Item Prices in Bulk

                                                                                                                Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices

                                                                                                              • Creator problem: Edit form View not displaying whole form

                                                                                                                I'm having problems with the form in my database. The edit view is not showing the whole form: This is how it looks in the normal view: As you can see, there is a whole section in the bottom right of the form which is not displaying in the Edit View. This means that I can't change or delete any of these fields... Anybody had a similar problem or know a solution? Any help would be appreciated.   Cheers,

                                                                                                              • Vendor Master Enhancements for Faster Purchase Entry

                                                                                                                I’d like to suggest a few features that will improve accuracy and speed during purchase voucher entry: Automated Item Tax Preference in Vendor Master Add an option to define item tax preference in the vendor master. Once set, this preference should automatically

                                                                                                              • Quick Item Search & Auto-suggestion for Invoices

                                                                                                                Hi Team, I am facing an issue while creating invoices in Zoho Books. Currently, I have to type the full item name in the correct sequence and spelling for it to appear. For example, my item name is: "Distemper Acri Silk Special White 10kg" If I type something

                                                                                                              • Integrating Chatbot with Zoho Creator Application

                                                                                                                Is it possible to integrate a chatbot with a Zoho Creator application?

                                                                                                              • Average Costing / Weighted Average Costing

                                                                                                                Hello fellow maadirs. I understand Zoho Books uses FIFO method of dealing with inventory costing, but do you guys have any plans to introduce average costing? We indians need average costing. It's part of our culture. Please. I beg thee. Thanks.

                                                                                                              • 'Add Tax To Amount' not reflected in Invoice

                                                                                                                Hi Zoho Support, I'm experiencing an issue with tax calculation display in my invoice template. Despite having "Add tax to amount" box checked in the template settings, the Amount column is not showing the tax-inclusive total for line items. Current behaviour:

                                                                                                              • "Subject" or "Narration"in Customer Statement

                                                                                                                Dear Sir, While creating invoice, we are giving in "Subject" the purpose of invoice. For Example - "GST for the month of Aug 23", IT return FY 22-23", "Consultancy", Internal Audit for May 23". But this subject is not coming in Customer Statement. Only

                                                                                                              • A real WYSIWYG field instead of the limited rich text

                                                                                                                Hi to everyone A "real" WYSIWYG or HTML field that outputs good HTML code when accessed through the API would be excellent. I tried to use the rich text field, but the styling options are limited. For example, there are no heading tags (h1 to h6), and

                                                                                                              • Next Page