Filter

[JAINCH7]

Hi All,

I have data as below:

A. Table 1: Wholesaler data

Field: 1) Sell-in (Unit), 2) Sell-in ($), 3) Sell-out (unit), 4) Sell-out ($)

A. Table 1: Product data

Field: 1) Sell-in (Unit), 2) Sell-in ($), 3) Sell-out (unit), 4) Sell-out ($)

I want to create a single filter as  (Unit/ $) only for both the data sets for my bar chart

Please help me how to do that

[Saravanan_Desingh]

Please show some sample data and expected output.

[JAINCH7]

Below is sample table with expected outcome. Also i want to apply a filter with Top 5, Top 10 and others ranking. 

[Saravanan_Desingh]

Are you looking something like this?

QUALIFY *;
Product:
LOAD RowNo() As RowID, * INLINE [
    Product, Cal. year / month, Month_Year_Flag, Sell In (Units), Sell In ($), Sell Out (Units), Sell Out ($)
    ABC, JUN 2020, Month, 414.53, 88405.14, 203.26, 27913.11
    ABC, JUN 2020, Month, 48.81, 51401.47, 948.33, 67086.23
    ABC, JUN 2020, Month, 714.41, 52025.59, 308.62, 43790.43
    ABC, JUN 2020, Month, 101.91, 11119.80, 394.17, 78448.82
    ABC, JUN 2020, Month, 743.58, 90704.88, 311.84, 84530.88
    ABC, JUN 2020, Month, 688.86, 14637.97, 956.27, 57478.21
];

Wholesale:
LOAD RowNo() As RowID, * INLINE [
    Product, Cal. year / month, Month_Year_Flag, Sell In (Units), Sell In ($), Sell Out (Units), Sell Out ($)
    ABC, JUN 2020, Month, 414.53, 88405.14, 203.26, 27913.11
    ABC, JUN 2020, Month, 48.81, 51401.47, 948.33, 67086.23
    ABC, JUN 2020, Month, 714.41, 52025.59, 308.62, 43790.43
    ABC, JUN 2020, Month, 101.91, 11119.80, 394.17, 78448.82
    ABC, JUN 2020, Month, 743.58, 90704.88, 311.84, 84530.88
    ABC, JUN 2020, Month, 688.86, 14637.97, 956.27, 57478.21
];

Check the container object in the right top, which has all the four Charts together.

[JAINCH7]

Yes, A filter pan which includes Unit and $. After selecting any of the value, below chart values change accordingly.