Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
skumarqv11
Contributor III
Contributor III
‎2018-08-02 08:48 AM

Grouping the data in Pivot?

Hi Folks,

I have a scenario below. I want to show the data in pivot if we collapse to Type level Its default showing 30147 as per pivot functionality but I need to show data like 3rd table below ( In Pivot I Need).

I need to sum where scale is millions but I don't want to sum for Count and %. I need to show all the data which is like 3rd table.

Can you please help me on this?

338 Views
0 Likes
0 Replies