How can I Hide expression in Pivot Table QV11

[#1]

HI,

I am using QV11, Quick glance about variables (Expressions) I have in Pivot Table:

1. Total Orders : [ Expression - (count(distinct(order_number))]

2. Promotional Orders : [ Expression - (count(distinct(if(promo_order_flag=1, order_number)))]

3. Promotional Orders % :  Expression -  Calculated field from above 2: [1] / [2] =  [Promotional Orders] / [Total Orders]

I want to display Promotional Orders and Promotional Orders % in a Pivot Table.

Can you please help in Hiding 1. Total Orders But use it in calculation to create 3. Promotional Orders %

Many Thanks and Regards

- Deep

[Sokkorn]

Hi Deep,

You may try this. Go to Expression -> check on Conditional with expression 1<>1

Rgds,

Sokkorn

[#3]

Hi Sokkorn,

Thank You for suggestion, but unfortunately it is not working for me.

It Hide Total orders successfully but also I loose 3. Promotional Orders % (where I was using total orders).

Please find screenshot below with Before(Green) and After (Red)

many Thanks

- Deep

[Sokkorn]

Hi Deep,

Is it possible to share your app?

Rgds,

Sokkorn

[#5]

Please find the attached file

[Sokkorn · Accepted solution]

Hi Deep,

If the [Total Order] not require to show in chart, then why don't we use [Promotional Orders]/count( {$<promo_order_flag =, year_no=, day_no=, month_no=, redemption_type=>}distinct order_number)

Or keep [Total Order], but use macro

!

[hannan_t]

Try this and hopefully you'll get your results.

1. Promotional Orders : [ Expression - (count(distinct(if(promo_order_flag=1, order_number)))]

2. Promotional Orders % :  Expression -  Calculated field from above 2: [1] / [(count(distinct(order_number))] =  [Promotional Orders] / [Total Orders]

[#8]

Thank You Guys,

I used part of both solutions and it is working now

Thank You for your help!

Regards

- deep