Skip to main content

Peliqan

Try for free
Request a demo

Google Sheets

Data filtering and pivoting for analysis

SQL query for Google Sheets

Retrieve total sales amount for each product category and display them in separate columns.

SELECT SUM(CASE WHEN product_category = ‘Category A’ THEN sales_amount ELSE 0 END) AS Category_A_Sales, SUM(CASE WHEN product_category = ‘Category B’ THEN sales_amount ELSE 0 END) AS Category_B_Sales, SUM(CASE WHEN product_category = ‘Category C’ THEN sales_amount ELSE 0 END) AS Category_C_Sales FROM table_name

Try this query now in Google Sheets

Google Sheets data model

Data model coming soon!

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed