Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to show data in a line graph for the current fiscal year-FY20 (fiscal year starts from Feb'19-Jan'20).
The values in the Fiscal Year = FY20,FY19,FY18,FY17...
I want to write a set analysis to show only FY20 data. The measure in my graph is
Count({<Enabled = {'1'},Classification = {'CUSTOMER'}>} distinct Keys) and Dimension is Fiscal Year. How should I make this graph to show only FY20 data?
Try something like this...
Count({<
Enabled = {'1'},
VClassification = {'CUSTOMER'},
[Fiscal Year] = {'$(=maxstring([Fiscal Year]))'}
>} distinct Keys)
Try something like this...
Count({<
Enabled = {'1'},
VClassification = {'CUSTOMER'},
[Fiscal Year] = {'$(=maxstring([Fiscal Year]))'}
>} distinct Keys)