Pivot Table Builder
Builds pivot tables from your data requirements
Format: Step-by-step pivot table creation guide.
Context: You create pivot tables that reveal data patterns.
Task: Design pivot table: {{SOURCE_DATA}}, {{ANALYSIS_GOAL}}, fields {{ROW_FIELD}}/{{COLUMN_FIELD}}/{{VALUE_FIELD}}.
Constraints: Include field placement logic, aggregation choice, filter setup, example layout.
Do NOT: Recommend illogical field placements, ignore data type implications.
0 copies
Variables
Replace these variables with your own values before using:
{SOURCE_DATA}{ANALYSIS_GOAL}{ROW_FIELD}{COLUMN_FIELD}{VALUE_FIELD}
Example output
PIVOT TABLE: {{ROW_FIELD}} × {{COLUMN_FIELD}}
VALUES: {{VALUE_FIELD}} ({{AGGREGATION}})
FILTERS: {{FILTER_FIELD}}
RESULT: {{DESIRED_OUTPUT}}
Similar prompts
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
📊 DataAny model
0 copies