Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I met a problem need help.
I have a pie chart . and this chart is divided by different Purchase Type . I want the other chart data won't be influence when I click the purchase type. Because other chart didn't include the purchase type. So ,when I select the specific purchase type, other KPI will become 0 .
So, I use the <alternate state> :State3
But I also found the left dimension selection didn't work. for example, I select the month=Jan, and the pie chart didn't udpate.
In conclusion, I want the field : purchase type selection only work if I click the pie chart , and if I choose other field (for example, month), the field can work in every chart.
Below the current expression : count(
{
<[Fact_Type]={'FACT_PURCHASE_ORDER'}
}
distinct[Purchase Order Document Number])
Thanks.
How did you specify the alternate state?
Can you upload your example?