SharmaHimanshu
5 years agoQrew Trainee
Pie Chart: Consolidate more than 1 field as a slice.
Hello,
Is it possible to consolidate more than 1 column to show as a 1 slice on a pie chart?
Requirement:
3 different Fields in QB tables are:
Passed by Vendor
Passed by Retail
Passed by Customer
Pie chart with 2 slices is needed in following way:
1st Slice sums records with all 3 field values = 1
2nd Slice sums rest of the records i.e which do not have all 3 field values = 1
In Pie chart options I see, Series & Data Values but can not figure out how to aggregate 3 fields in there.
Could it be possible to use a Formula field/Report Formula field in here?
Please suggest.
Thanks in advance.
------------------------------
Sharma Himanshu
------------------------------
- First create a new formula text field called [Passed first try] using the formula above.
You will select [Passed first try] the "Series"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------