How to display data in webi cross table in different format?
I have the below data
| Week | Region | Sales | Profit |
| ---- | ------ | ----- | ------ |
| 1 | A | 100 | 50 |
| 1 | B | 150 | 25 |
| 2 | A | 120 | 80 |
| 2 | B | 110 | 75 |
And I would like to display it as below in crosstab.
| Weeks | 1 | 2 | 1 | 2 |
| Region | Sales | Sales | Profit |Profit |
| ------ | ----- | ----- | ------ | ----- |
| A | 100 | 120 | 50 | 80 |
| B | 150 | 110 | 25 | 75 |
However, the crosstable in Webi display as below.
| Weeks | 1 | 1 | 2 | 2 |
| Region | Sales | Profit | Sales |Profit |
| ------ | ----- | ----- | ----- | ----- |
| A | 100 | 50 | 120 | 80 |
| B | 150 | 25 | 110 | 75 |
Solution
You can do this by creating two crosstabs; one with Sales and the second with Profit.
Align the Profit crosstab to be right next to the Sales crosstab.
Next, select either header cell of the Profit crosstab and hide the column.
That's it.
- Calculate all missing values for specific data using pivot tables in pandas
- How to collapse pivot items that only have one sub-item with VBA?
- How to unpivot data that has multiple column groups in Google Sheets?
- transform/pivot array of objects based on values of a key and reconvert it back to original
- My column values show as (lists) and not (character/numeric/integer) after using pivot_wider
- Dynamically generate columns for crosstab in PostgreSQL
- Lock Filter in Pivot Table
- "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns" Error
- How to use a data frame containing counts to run contingency analysis
- How to apply conditional formatting only on the top level rows in the pivot table hierarchies
- R flextable proc_freq remove counts
- How to avoid transposition of duplicates into lists with pivot_wider?
- How to group row_fields using aspose-cells-python 24.10.0 into one cell
- Counting start and end states with a pivot table in R
- Polars Pivot treats null values as 0 when summing
- Calculate percentage of rows containing a string, grouped by month
- Excel 2010 VSTO CreatePivotTable fails
- Pivoting a table using crosstab() in PostgreSQL
- VBA to manually position an Excel pivot when AutoSort is blocked
- Format Multienumeration Data for Pivot Table
- Turn cell values into columns in MySQL
- Changing the Date Format for GROUPED dates in a PIVOT TABLE
- Why does this attempt to create a PivotTable (Excel Interop) fail?
- Add custom columns to pivot table
- Modifing a Pandas Dataframe using Pivot Tables or Group By
- Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class' with Data Model Pivot Table
- VBA create pivot with "data is added to the Data Model"
- Pd pivot table lambda function to join column values with exceptions not working
- In Pivot columns are coming in reverse order
- Example of how to create a Pivot Table in ClosedXML