You can set a calculation condition that will show certain things in your chart based on selections. The calculation condition can be entered in the Properties panel, Add-Ons->Data Handling-> Calculation Condition prompt box
If([ListBoxMetric] = 'Count',(count(Orders)),(sum(Sales)))
This statement will see if your ListBoxMetric is 'Count.' If it is, it will calculate the expression, count(Orders). If it is not, such as if Sum is selected from your listbox, it will calculate the expression sum(Sales).
Does this help?
Use Load inline for create Metrics Table
LOAD * INLINE [
Then in the App, add Filter Panel with the metrics, and add a conditional in the PivotTable expression.
IF(Metric='Count', COUNT(<Add your measure>),
IF(Metric='Sum',SUM(<Add your measure>),'Selected Metric')
This solves your demand.
Thanks for the reply chris and juan.
This will help when i have only one metrics.
Actually when i select Count , i have 5 metrics to show. like order count, shipment count , number of days like that.
And also i don't want to show metric column itself if i have not selected a metric from filter box.