While doing discovery on charts ,selections are not happening in following tables Energy sale and Revenue. Here Billing is main table got raw data remaining tables are having calculated fields (info : all are excel tables for POC). Do i need to create a separate Fact table ,if so help me on this issue please.
If you select a value in one table and the other tables are not filtered then the values in the CATEGORY field in the Billing table do not exist in the records in the other tables. Check your data.
If you select a value in one table and the other tables are not filtered then the values in the CATEGORY field in the Billing table do not exist in the records in the other tables. Check your data.
.png){kind=link}