Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
!
Hi Deep,
You may try this. Go to Expression -> check on Conditional with expression 1<>1
Rgds,
Sokkorn
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
Hi Deep,
Is it possible to share your app?
Rgds,
Sokkorn
Please find the attached file
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
!
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]
Thank You Guys,
I used part of both solutions and it is working now
Thank You for your help!
Regards
- deep