Calculation in Pivot Table

[provie98]

How can I get a calculation to show me a percentage in this pivot table?  For example, I want the percentage of accounts to total accounts for each group (Closed Account, In Progress, Lost Lead, etc).  The first line would be 7.7% (249 divided by 3232).  Any ideas would be appreciated.  Thanks!

[rustyfishbones]

Can you try sharing the App, a reduced version of it please

[provie98]

My apologies.  I posted it in the wrong forum.  I corrected it.  I wasn't creating an app.  Sorry!

[rustyfishbones]

not sure what you mean,

can you share the Qlikview Application or QVW so we can try to help

[provie98]

Here's an example in Excel.  I'm trying to add the percentage of the Amount vs the Total Amount by eUser_ID and by activity Status.  I think I might have to use Set Analysis since it's in a Pivot Table but I'm not sure.  For example, for Cracker Jack the number percentage is 14.52% (115/792).  Hope this helps.

[Gysbert_Wassenaar]

Perhaps this discussion can help you: Percentage % Total for Dimension in Pivot Table

If not, try reading these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[provie98]

Thanks Mr. Obvious. 

[rustyfishbones]

Using the Excel example you could say

[rustyfishbones · Accepted solution]

Easy now!

Gysbert is one of the best people, if not the best we have on the Qlik Community.

You should check all resources before asking a question.

Don't be so disrespectful!

Regards

Alan