Add expression vertically in pivot tables

[elaineng]

I have a qlikview report which consist of 2 simple tables:

UnitID is the key to link both table.

I would like to have a analytic table which count the total sold unit by 2 dimension:

Agent & by Unit Layout. Add the bottom of the table, I would like to calculate the percentage of sales which is sold unit/Number of Unit Type and Available Unit (Number of Unit Type - Sold Unit)

Like the table below

[alex00321]

Not quite clear on the requirement...

[elaineng]

The table went missing. 

I would like to combined/joined the 3 table together become one like below:

[anushree1 · Accepted solution]

Please check if the attached file works for you , please check the pivot on top

[nikkia1236]

To change the data to a vertical layout, drag the Values button in the Pivot Table Field List, from the Column Labels area to the Row Labels area. In most cases, the Values button should be positioned below the other fields in the Row Labels area. Official Site

[karryscar21]

Tellthebell is a Sweepstakes Program for the customers of Taco Bell. No matter whether they have the purchase receipt with them or not. It is possible to enter the Tellthebell Sweepstakes.

[Drakesmith21]

There are several franchises of the restaurant across the nation thus making it the largest burger chains in the country in about 2,200 locations across 21 states as well as Guam. https://jacklistenssurvey.shop/ 

[juanneumann72]

YourTexasBenefits is the login portal for the Texas state benefit programs. Login to YourTexasBenefits.com gives access to the Your Texas Benefits portal for those who need to apply for SNAP food, health care, Support Services, and TANF Cash Help.

[Drakesmith21]

With the help of the WalgreensListens survey team, you could carry out the survey in a perfect manner. Once you are done with the survey, you will be asked to accept the rules of the game and that’s it!

https://walgreenslistensus.shop/ 

[james46541]

MONOPOLY Collect to Win Game Stamps: Collect to Win Game Stamps describe the name of a MONOPOLY street property, location, airport, highway or RMHC location that corresponds to a street property, location, airport, highway or RMHC location on the Game Board. A Participant must collect and combine all of the original Collect to Win Game Stamps of the same colour group (or, if applicable, all of the airport Collect to Win 23 Game Stamps or both highways or all of the RMHC Collect to Win locations) necessary to form a potential Winning Combination for a Collect to Win Prize. The Game Stamp numbers of the Collect to Win Game Stamps rare mcdonalds pieces that must be collected to form a potential Winning Combination for a Collect to Win Prize can be found on individual Collect to Win Game Stamps and in Rule 4.D. below. If a Participant collects all of the Collect to Win Game Stamps required to complete a Winning Combination, that Participant is the potential winner of the Prize identified on the applicable Collect to Win Game Stamps and, in Rule 4.D. of these Official Rules, subject to verification of the Collect to Win Game Stamps, of the potential Winning Combination and of the Participant’s compliance with these Official Rules. The Sponsor will not honour and is not responsible for any combination of Game Stamps that is incomplete or any purported game stamp(s) which is/are copies of any genuine, original Game Stamp.