Forum

Cross Filter and Hi...
 
Notifications
Clear all

Cross Filter and Highlight Excel Charts like Power BI

2 Posts
2 Users
0 Reactions
60 Views
(@bernhard_wuestagilent-com)
Posts: 1
New Member
Topic starter
 

I tried to apply my own data but I am sort of stuck.

I do have sales data with many columns where most of them are from our financial database and others are calculated in my table.

I saw the webinar on cross filter but I am not sure what I am doing wrong.

The main data contains for example country name product ID and product description, Amount in $, Product group 1, product group 2, Sales Agent, Fiscal year, month, quarter data.

WHat I am trying is using the country name as chart in the dashboard and cross filter by product group 1 or 2,.

I build a second table for the product group 2  and followed the procedure in the webinar. 

The tables created are all mixed up and I am not sure if my logic is correct.

Any help is appreciated. 

 
Posted : 17/05/2021 5:29 am
Anders Sehlstedt
(@sehlsan)
Posts: 969
Prominent Member
 

Hello,

A sample file showing your data (not necessarily the real sales data) and what you are struggling with would be of good help here.

Br,
Anders

 
Posted : 17/05/2021 5:50 pm
Share: