Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
flygstolen_fred
Creator
Creator

Categorize pivot table

Hi,

I have a SQL table with sales data that I want to "categorize" in a pivot table.

InvoiceLines:

SKU
PriceCostUnitsDate
123120902
12498451
12575701

I want to categorize my pivot table to look like this:

JanFebMar
Salessum(Price*Units)sum(Price*Units)sum(Price*Units)
Costsum(Cost*Units)sum(Cost*Units)sum(Cost*Units)
Profitsum((Price-Cost)*Units)sum((Price-Cost)*Units)sum((Price-Cost)*Units)

How do I create categories like in the left column? Any help are appreciated.

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Create a regular pivot table with Month Dimension and your expressions.

Move the Month to column and values (basically the expressions) to Row and you should achieve it. See below !

Capture.PNG

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Create a regular pivot table with Month Dimension and your expressions.

Move the Month to column and values (basically the expressions) to Row and you should achieve it. See below !

Capture.PNG

Anil_Babu_Samineni

i am not seen anywhere field holding month names. can you share exactly how looks the table in DB?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
flygstolen_fred
Creator
Creator
Author

Thanks Dilip for helping out!